Jump to content

Basic MySQL dump file question


Mouse

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....

Link to comment
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

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.