phpMyAdmin restore

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
$var
Forum Contributor
Posts: 317
Joined: Thu Aug 18, 2005 8:30 pm
Location: Toronto

phpMyAdmin restore

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:)
User avatar
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.
User avatar
$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.
Charles256
DevNet Resident
Posts: 1375
Joined: Fri Sep 16, 2005 9:06 pm

Post by Charles256 »

not a problem! :-D
Post Reply