[How To] Increase import file size in phpmyadmin

By default when you want to import sql file in phpmyadmin, in “File to Import:” section you can see (Max: 2MiB). That is php’s file upload limit. To increase it find php.ini file $ locate...

[How To] Setup MySQL Listen on Localhost Only

If You want that MySQL listen only to localhost edit the MySQL configuration file and write bind-address=127.0.0.1 Configuration file can be /etc/my.cnf or /etc/mysql/my.cnf Next, you will need to restart the database server: $ sudo /etc/init.d/mysql...

How To Restore and Import MySQL Database

You should upload the dump file to the MySQL server, and type this command to import the databases into the MySQL server. mysql -u username –ppassword database_name < dump.sql Don’t put space after -p and then password

How to Online Backup Innodb Tables

Backup the database inevitable cause MySQL server unavailable to applications because when exporting, all tables acquired a global read lock using FLUSH TABLES WITH READ LOCK at the beginning of the dump until finish. So although READ statements can proceed, all INSERT, UPDATE and DELETE statements will have...

How to Export, Backup Or Dump A MySQL Database

To export a MySQL database into a dump file, simply type the following command syntax in the shell. mysqldump -u username –ppassword database_name > dump.sql Replace username, password, database_name and dump.sql as your needs. All data, tables, structures and database of database_name will be backed up...

How to Export A MySQL Database Structure

If You need to export only the MySQL database’s tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql Don’t put space after -p and then password

How to Dump Several MySQL Databases Into Text File

Use –databases option for exporting several databases. mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] >dump.sql

How to Dump All Databases in MySQL Server

To damp all MySQL databases, use the –all-databases option. mysqldump -u username –p password –all-databases > dump.sql