Tranfer websites: DA Backup - no databases after restore

E

Egon

Verified User
Joined
Oct 5, 2004
Messages
8
I´m transferring my websites to another hosting company. Both use DA 1.23.3. With my "old" DA i created a backup (checked all options before started the backup) and downloaded the file to my pc (approx 520mb).

After that i uploaded the backup to the backup folder on my new hosting. In DA i wanted to restore the backup and selected the backup file. After that i checked all restore options.

To my suprise all domains (folders and files) where restored but not my databases. Did i do something wrong?

For your information i checked out the gzipped file and saw that the sql and conf files are included
 
Last edited:
I am taking a shot in the dark here since I don't know much about DA's backup system but maybe you have to use PHPMyAdmin to restore the dumped databases????? I notice when you backup in DA, the logs say "Dumping xxxxx" where xxxxx is the database name. When you dump a MySQL database, it saves the database in a text file which includes the SQL statements and the data needed to restore your database. If this is the case, create new blank databases with the same names as your old ones and then use PHPMyAdmin and the dumped database files from your backup to restore the databases.

Maybe someone else can explain better. Or maybe I'm way off and don't know what I'm talking about. :rolleyes:

Louie
 
Check the control panel on your new host. Make sure the correct number of databases are setup for your new account. We had this issue with one customer recently transferring in from another host - similar to your situatution The reseller never setup databases for the customer, thus, no restore ability.

Might be something to check out.

Joe
 
I am taking a shot in the dark here since I don't know much about DA's backup system but maybe you have to use PHPMyAdmin to restore the dumped databases????? I notice when you backup in DA, the logs say "Dumping xxxxx" where xxxxx is the database name. When you dump a MySQL database, it saves the database in a text file which includes the SQL statements and the data needed to restore your database. If this is the case, create new blank databases with the same names as your old ones and then use PHPMyAdmin and the dumped database files from your backup to restore the databases.
Click to expand...

I think that using PHPMyAdmin is my last resort when the normal backup procedure doesnt work at all. Then I can restore the databases manually.

Check the control panel on your new host. Make sure the correct number of databases are setup for your new account. We had this issue with one customer recently transferring in from another host - similar to your situatution The reseller never setup databases for the customer, thus, no restore ability.
Click to expand...

Hmm, checked the control panel:

Disk Space (mb) 0.0 2500
Bandwidth (gb) 0.0000 24.414
E-Mails 2 250
Ftp Accounts 4 250
Databases 0 250

Seems like the amounts of databases (250) should be enough to handle 6 which come from the backupfile

I thing i have been thinking about is that my username is different now than with the old hosting company?
 
Egon said:
I think that using PHPMyAdmin is my last resort when the normal backup procedure doesnt work at all. Then I can restore the databases manually.
Click to expand...

I was suggesting that maybe this is how you are supposed to restore the databases on a DA restore. ???

Louie
 
louie55 said:
I was suggesting that maybe this is how you are supposed to restore the databases on a DA restore. ???

Louie
Click to expand...

Well as i´m not able to restore it thru DA you could be right, but when you try to do restore you can check the option to restore your database.
 
Since the username is part of the database name when using DA I'd guess that you won't get an automatic restore if you change the username.

Jeff
 
What if i changed the information in the .conf files (in the backup file) so the user information matches with the current username? Would that work?
 
You must log in or register to reply here.
Back
Top