Importing my vb database in a new server

[Sworm1]

Hi all,
i'm transfering my board to a new hoster,
i've created a new database with cpanel, now, i want to import my old database dump in the new one, but the old database is to big of the maximun dimension allowed for the new db .
Old database is 77 MB
Maximun dimension allowed for importing in the new db is 51,200 Kib .....
How can i do for import the old database in the new?
I'm using PhpmyAdmin and MySql 5.0.51 a

thanks

[Steve Machol]

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

[Sworm1]

Tx for the reply ,
but the db dump borned from vBulletin board (with the dedicated function that allow to create a dump in one ftp folder) can be restored by SSH?
Or is possible restore with SSH only the dump borned with SSH?

P.S.
I have SSH in the old and in the new host

[Steve Machol]

That depends on if it's a good backup or not. The only way to now for sure is to restore it.

[Sworm1]

That depends on if it's a good backup or not. The only way to now for sure is to restore it.

thanks,
i would try the import before the end domain transfer ..... (other 4 calendar days).
This is the first time that i can try this operation.....
Can you explain me what is the function after the ftp dump import on new server in SmartFtp ?


My new db is named rick79_bbd3 and the username is rick79 , the path of new server that contain the .sql is the main forum path is:
home/rick79/public_html/forums

Now, is correct this function?
mysql -u rick79 -p rick79_bbd3 < /home/rick79/forums/backupname.sql

If is correct,
How can i add this in smart ftp?

Thanks for the support.

[Sworm1]

Nosorry, no smart ftp, but Putty......