Lost my database!

[4string]

I was changing hosts. I wanted the domain to propagate ASAP so I went ahead and switched it to the new host nameservers. When I logged in using the IP address all my mySQL databases were gone! I have some recent backups, but I'd prefer the fresh one.

I'm switching the nameservers back and crossing my fingers. I just don't see how it would matter.

I did a full site backup for the entire (shared) account beforehand. Where in the file structure are the databases stored? I can't find them.

[txbakers]

Sorry to hear you lost your data - that's not good.

Generaly the mySQL files are stored in C:\ProgramFiles\mySQL\data

But they can be anywhere, depending on where you installed the DB or where your host puts the data files.

[mack]

On *nix it will usualy be /var/lib/mysql

Mack.

[volatilegx]

Were you logging in using phpmyadmin or through shell access? Try shell access.

[marcs]

Or, use mysqldump to export your data from the old host and then import data on your new account.

[4string]

They magically reappeared!

I guess the host must have screwed something up right at the same time I was doing a lot of major moving around with things. Strange.

I really appreciate all of your replies. Thanks!

4