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 at the bottom of the page. Thank you!
Bookmark with: | del.icio.us | Digg it | Netscape | Newsvine | Yahoo MyWeb |
Leave a Reply
You must be logged in to post a comment.