Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
$var
- Forum Contributor
- Posts: 317
- Joined: Thu Aug 18, 2005 8:30 pm
- Location: Toronto
Post
by $var »
Hello,
I have a question about restoring a backup from phpMyAdmin.
I have successfully exported the database as a zipped file.
How do you upload the db file if your database goes down?
It hasn't happened, but I would like to be prepared.
-
Charles256
- DevNet Resident
- Posts: 1375
- Joined: Fri Sep 16, 2005 9:06 pm
Post
by Charles256 »
click SQL and then i has the option to upload a zip file for sql statement which effectively backs you up..if memory serves me:)
-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
phpMyAdmin doesn't die if your MySQL server is dead.. although it won't be able to connect.. Once it can connect, you can upload your backup.
-
$var
- Forum Contributor
- Posts: 317
- Joined: Thu Aug 18, 2005 8:30 pm
- Location: Toronto
Post
by $var »
Thanks Charles256.
I was just missing that.