Importing big .sql files in MySQL
May 18th, 2007 by Anthony Curreri
You can safely use PHPMyAdmin to export a database, just save it to a file on your computer.
Then use a program in WinSCP to upload that file to your Web Server.
Next, edit your /etc/my.cnf to include the following line:
set-variable=max_allowed_packet=64M
Then start the MySQL command console ‘mysql -u root -p’, and type ’source localhost.sql’
If you found this helpful, help me by checking out the ads on the right. Thank you!
Link to this post! Copy and paste this code into your blog or website:
<a href="http://www.mailbeyond.com/importing-big-sql-files-in-mysql"> Importing big .sql files in MySQL </a>