Problems importing my old database to the new host

[coolphim]

My exported my database file (.sql) which is 14MB. However, my new host database only allows to import file no bigger than 8MB. I contacted the host supporter and they told me to split my database file to import it. Please, show me how to split my .sql file into 2 parts so that i can import it to my new host please, thanks

[Ntfu2]

try uploading it to your FTP space, and then tell your hosting company where its at and see if they can restore it for you.

If you have SSH access you should be able to restore it yourself also

[noppid]

If you have shell access, upload it and mysql it in.

If you only have ftp, you can do it with a cron job.


mysql -u DB_USER_NAME -pDB_PASSWORD DB_NAME < /home/ACCOUNT_NAME/BACKUP_FILE_NAME.sql

[coolphim]

please show me more information about using SSH access or cron job, thanks

[noppid]

How to Backup MySql Databases (http://www.cpurigs.com/forums/showthread.php?t=2699). Hope that helps.