Quantcast
Image

Search Results for: tables

How to install gpart on Ubuntu

By  •  December 2, 2021

gpart is a tool to read your hard drive for existing filesystems and then use the info to guess for partitions. It could be used to scan for and …
Read More

How to scrape HTML table using Scrapy

By  •  December 2, 2021

The common way of presenting data on websites is usingHTML table, and Scrapy is perfect for the job.

An HTML table starts with a table tag with …
Read More

How to reset MySQL/MariaDB root password

By  •  December 2, 2021

MySQL is one of the world's most popular open-source databases. It is mainly used on many database-enabled websites, mostly for being free and powerful.

If you happen …
Read More

How to import CSV files to MySQL/MariaDB table

By  •  December 2, 2021

You can import data from CSV (Comma-Separated Values) files directly to MySQL tables using LOAD DATA statement or by using MySQL's own mysqlimport tool.

To be able …
Read More

How to connect to root MySQL account without sudo

By  •  December 2, 2021

You can only connect to root account for both MySQL and MariaDB if you are logged in to the system as root user or by using sudo. If not, …
Read More

How to configure table name case sensitivity for MySQL or MariaDB

By  •  December 2, 2021

MariaDB and MySQL table name is case sensitive if it's running on case-sensitive systems such as in Linux and Unix. Windows however does not enforce case sensitivity for its …
Read More

How to add PATH environment variable in Windows

By  •  December 2, 2021

PATH environment variable is a set of folders or directories where you store your executables such as scripts or binaries. It allows you to run the executables without needing …
Read More

How to get hardware information in Linux

By  •  December 2, 2021

The Linux kernel keeps the information about your computer or system hardware. You can view the hardware information using general tools such as dmidecode or specialized tools such as …
Read More

How to format disk and partition in Linux

By  •  December 2, 2021

Disks and partitions need to be formatted before they could be mounted and used. Linux by default supports several filesystems, which would come with their pros and cons. Some …
Read More

How to change MySQL data directory

By  •  May 28, 2018

shakir@anduril:~/Dropbox/Workspace/Apache/mirror/oseems.com$ sudo vi /etc/mysql/my.cnf
shakir@anduril:~/Dropbox/Workspace/Apache/mirror/oseems.com$ sudo /etc/init.d/apparmor restart
* Reloading AppArmor profiles
Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox
Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd

 ...done.

shakir@anduril:~/Dropbox/Workspace/Apache/mirror/oseems.com$ sudo vi /etc/apparmor.d/usr.sbin.mysqld
shakir@anduril:~/Dropbox/Workspace/Apache/mirror/oseems.com$ sudo /etc/init.d/apparmor restart
* Reloading AppArmor profiles
Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox
Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd

 ...done.

shakir@anduril:~/Dropbox/Workspace/Apache/mirror/oseems.com$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld

 ...done.

* Starting MySQL database server mysqld

 ...done.

* Checking for tables which need an upgrade, are corrupt or were
not closed cleanly.

Top