Re: Restoring 500MB .sql file into the database...
Hi!!
If you have shell access..then you can dump easily using mysql command line utility..
On Win (MySQL Server is running on same host)
C:\mysql\bin\>mysql -uuserName -ppassword databasename < yourdumpfilehere.sql
On Win (on MySQL Server is running remote host)
C:\mysql\bin\>mysql -hremotehostname -uuserName -ppassword databasename < yourdumpfilehere.sql
On *nix..(MySQL Server is running on same host)
#mysql -uuserName -ppassword databasename < yourdumpfilehere.sql
On *nix..(MySQL Server is running on remote host)
#mysql -hremotehostname -uuserName -ppassword databasename < yourdumpfilehere.sql
If still you want to split file & then want to dump then Check out this..
http://www.ozerov.de/bigdump.php
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221