Tag: MySQL

phpmyadmin

[How To] Increase import file size in PHPMyAdmin

By default when you want to import sql file size is 2MB in PHPMyAdmin.That is PHP’s file upload limit. To change maximum import file size do following steps. Find php.ini file $ locate php.ini /etc/php5/apache2/php.ini …
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 …
MySQL

[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 …
MySQL

[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
MySQL

[How To] Backup Only Data of a MySQL Database

For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump -u username -ppassword –no-create-info database_name > dump.sql Use this …
[How To] Backup MySQL Databases

[How To] Backup MySQL Databases

There are two methods to backup MySQL, first method is by copying all files such have extentions *.frm, *.MYD, and *.MYI, and second is by using mysqlhotcopy utility, this methods are only for MyISAM tables.