PhpMyAdmin

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Is there a script i could use to restore a full database from a .sql file i have. Im not restoring on top of a database. Is this possible (the file is on my web server) if so how.

Thanks Jack

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

If you have your own host you can install phpmyadmin and import the .sql file, if the file is large then phpmyadmin will time out so you may need to use other methods. Does your host support SSH you could use something like putty to upload the file. Failing that try bigdump.

 

My Hosts got phpmyadmin by default, thanks si im off to try some of those methods!

Jackd

 

PhpMyAdmin should work and ive figured out what im going to do with it. But unfortunatley i need to wait till i get home to try it.

 

so are you in school now Jack?

 

No im with a friend, i think ive got another 2 weeks off something like that i think because my birthday is on sunday so it must be another 2 weeks

 

you enjoy yourself Jack, cuz when school starts, things are never the same, until the next hols...

btw: hope your not smoking behind the shed!

 

CM, LOL! Smoking Behind The Shed

 

Depends on what is actualy in the .sql file, but doing something like

Code:

mysql < query.sql

should be all you need.

Harry.

 

Thanks Harry Ill tell you the results soon

 

Yes i got it working with bigdump though i had to edit the dump a bit. Phpmyadmin just kept timing out. Thank you everybody who contributed here.

Jack

 

Get hold of a copy of Mysql front. Its a great frontend for mysql and runs on your pc so doesnt present the same security risks as using phpmyadmin (looking at our server logs at work, people try every combination of url to get to phpmyadmin on your site in the hope and getting in and messing up your database). We always use Mysql Front at work, and its really handy. On the downside, it has been discontinued due to legal reasons http://www.mysqlfront.de/ but you can still get copies here and there. Also good when using large sql dumps (we backup our databases for clients which run into the excess of 100+mb).

If you can get a copy of Mysql front, you will love it.

Jodsclass

 

Thanks I'll try that later

Jack