Jump to content

Archived

This topic is now archived and is closed to further replies.

Mouse

Basic MySQL dump file question

Recommended Posts

Hello All,

 

First things first i am DYSLEXIC... so please make any replies as clear as possible, by this i mean in english as oposed to techie where possible... many thanks.

 

My reunion site has been a flat site for years and is now going dynamic thanks to PHP and MySQL. a friend has done much of the work for me and has sent me back a zipped PHP website which i have opened and unpacked successfully into my apache htdocs file and it works well. my issue is with the SQL file (a dump file i think you'd call it?)

 

i am trying to put it all back together. i think(?) the information i need to link it is...

 

$dbconn = mysql_connect("localhost","ABC","ABC123"); mysql_select_db("dlp");

 

what i need to know is how to unpack the dump file, where to save it relative to the website and if possible how to fill in the database connections for a testing server on my machine in Dreamweaver.

 

Many thanks in advance

 

forgot to mention, i cant ask my friend who did the work for me, at the moment as he's on honeymoon....

Share this post


Link to post
Share on other sites

Hello,

 

Do you have CPanel?

If so, you can go to Mysql -> PHPMyAdmin -> Operations (i think) -> then something like "Execute Sql file" or something like that.

 

Anyways, browse to the file and run (on your local machine) it and that should be all you need to do.

 

If you do not have CPanel, then if you have ssh, all you need to do is save the file (probably with ftp, where it realy doesn't matter, as long as you know where you have saved it) and log into your server via ssh, and type:

mysql -u your_username -p < your_file.sql

Enter password: ********

 

And then, i think it should work.

 

HTH,

Peter

 

Share this post


Link to post
Share on other sites

Alternatively, you can break up your file by tables, and use LOAD DATA INFILE.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.