Import Mysql Database with Centos 7

Tango

The President
3,641
978
113
2009
2,265
If your database is above 1GB it is worth while making a few tweaks to speed things up, Some large databases could take days with default settings & minutes with a few tweaks.

Install an editor if needed.

Code:
yum -y install nano



Code:
nano /etc/my.cnf.d/server.cnf



At the end of [mysqld] section add.
Code:
max_allowed_packet = 1G
net_buffer_length= 1G

Save the file CTRL+o, ENTER, CTRL+x
Restart Mysql to update config
Code:
service mysqld restart

Goto phpmyadmin and create a database eg. myforumbackup be sure to select the same charset as your old database used.



Goto the directory containing your database file, upload via FTP or Wget the file.


Code:
cd /home
ll

Import the database, this presumes you know mysql root password, you will be prompted to enter it.


Code:
mysql -uroot -p myforumbackup < myforumbackup.sql

Your database will now import, you can revert changes to my.cnf file when it's complete.
 
Top Bottom