Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Restore problem Options · View
Guest
#1 Posted : Saturday, January 21, 2012 11:00:25 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 733
Hi there:

I see your restore thread on the forum:

"MySqlBF creates *.sql script files to restore the database structure and data. You just have to run these files on the server to restore the database. Most often (if you use phpMyAdmin) you just select SQL tab in phpMyAdmin, select the *.sql file and click "Go"."

You mention to just select SQL tab, but isn't that to run a query? When I choose the IMPORT tab, I open the file and click GO but I keep timing out. My DB is about 500mg.

Any suggestion appreciated. I look forward to using this! Also, I am a total newbie with all this!

AlexP
#2 Posted : Tuesday, January 24, 2012 1:48:38 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 180
Please try these steps:

1. Click on the icon labeled MySQL Databases in your control panel.
2. At the bottom of the screen in MySQL Databases you will see an option for PhpMyAdmin, click on it
3. Once in PhpMyAdmin you will see on the left side a drop down of your databases, select the database you would like to import to.
4. This will create some tabs at the top of the screen, click on SQL.
5. After clicking on SQL you will see a Text Box area and a file upload option.
6. Click browse on the file upload option and find your .sql file
7. After you have selected the file click GO and it will import your database. It may take a while to complete importing especially if your database is large.
Guest
#3 Posted : Tuesday, January 24, 2012 1:30:48 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 733
AlexP wrote:
Please try these steps:
5. After clicking on SQL you will see a Text Box area and a file upload option.
6. Click browse on the file upload option and find your .sql file
7. After you have selected the file click GO and it will import your database. It may take a while to complete importing especially if your database is large.


Unfortunately I am not seeing this. When I click on the SQL tab I see a large text box to accept a SQL query. No browse file field. Do you mean the IMPORT tab? If so that has the browse file field. I try it there but the file just times out.

AlexP
#4 Posted : Wednesday, January 25, 2012 7:47:44 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 180
There are a lot of docs about this. E.g.: http://codex.wordpress.o...our_Database_From_Backup
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.