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...

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...

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 to queue due to locked tables, as if MySQL is down or stalled. If you’re using InnoDB, –single-transaction is the way to minimize this locking time duration to almost non-existent as if performing an online backup. It works by reading the binary log coordinates as soon as the lock has been acquired, and lock is then immediately released. mysqldump -u username –ppassword –all-databases –single-transaction > dump.sql Don’t put space after -p and then...

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 into a mentioned file dump.sql. [alert]Don’t put space after -p and then...