Results 1 to 5 of 5
Thread: MySQL Database Restore?
-
11-05-2004, 03:57 AM #1Junior Guru Wannabe
- Join Date
- Oct 2004
- Posts
- 47
MySQL Database Restore?
I am transferring my web site to another provider. I try to transfer mysql database by download a backup from old provider and restore it using cpanel. Restore seem like succesful but when i check using phpmyadmin, its only created 10 tables while its suppose to have 21 tables. Any idea what really happened? Or can you all suggest me another way to restore the database?
-
11-05-2004, 04:28 AM #2Disabled
- Join Date
- Oct 2004
- Posts
- 13
The database should be taken backup once again using the following command,
mysql db_name < backup-file.sql
In the above command you should be in /var/lib/mysql directory and you should have root access, if you don't have one contact you hosting company.
In order to restore it,
mysql database_name < path/backup-file.sql
This will restore all the tables safely.
-
11-05-2004, 04:37 AM #3Wanna be a part?
- Join Date
- May 2004
- Location
- World Wide Web
- Posts
- 1,195
Or if you don't have SSH (for mysql db_name < backup-file.sql you need shell access) you can use PHPMyAdmin to backup (export) the database and than try importing the same to new server using PHPMyadmin.
≡ RVH Cloud - Every day hosting solutions since 2003≡
★ Shared Hosting ★ Reseller Hosting ★ VPS ★ Dedicated Servers ★ True 24 x 7 x 365 Support
-
11-05-2004, 06:34 AM #4Junior Guru Wannabe
- Join Date
- Oct 2004
- Posts
- 47
Thanks
btw contactsonia, i cant find import command at phpmyadmin
-
11-05-2004, 06:41 AM #5Junior Guru Wannabe
- Join Date
- Oct 2004
- Posts
- 47
ouch!
Everything is ok now, i should use SQL queries