Please help... MYSql dump

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kilerb
Forum Newbie
Posts: 2
Joined: Wed Mar 04, 2009 10:07 pm

Please help... MYSql dump

Post by kilerb »

Hi, I downloaded a php script. I've installed many in the past, but this is the first one that is asking me to dump a sql (looks like a text file) into my database. How do I do that? I went into plesk and I see how to make a database, and I see that there is an ssh terminal, but I have no clue how to dump this file into my database. Any help would be appreciated.

Thanks,
B
Last edited by kilerb on Wed Mar 04, 2009 11:24 pm, edited 1 time in total.
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Please help...

Post by JAB Creations »

Welcome to the forums.

Make titles that count. "Please help..." screams "I don't know how to summarize the issue at hand" and will scare away more advanced users who would otherwise be happy to help you.

I recommend starting with phpMyAdmin, you can "dump" MySQL by clicking on query..this is presuming you've got MySQL running and a user with permissions to an associated database. If you're doing this locally (localhost on your system) this typically isn't too difficult. I'll leave SSH to someone else.
kilerb
Forum Newbie
Posts: 2
Joined: Wed Mar 04, 2009 10:07 pm

Re: Please help...

Post by kilerb »

JAB Creations wrote:Welcome to the forums.

Make titles that count. "Please help..." screams "I don't know how to summarize the issue at hand" and will scare away more advanced users who would otherwise be happy to help you.

I recommend starting with phpMyAdmin, you can "dump" MySQL by clicking on query..this is presuming you've got MySQL running and a user with permissions to an associated database. If you're doing this locally (localhost on your system) this typically isn't too difficult. I'll leave SSH to someone else.
Thanks, I changed the title...

I have a virtual server with a few domains of mine on it that runs plesk. I'm going to try and get into phpmyadmin and see if i can figure this out. It won't say dump obviously. What would I be looking for in there?

Thanks!
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Please help... MYSql dump

Post by JAB Creations »

Once you've got phpMyAdmin running and you're inside a database look for the tab called "SQL". It'll have an empty textarea element which you can simply paste the MySQL code in to...this is code was exported and not just written out and not tested or anything. If it's not excessive feel free to post the SQL inside [ mysql ] BB code.

*edit* I'm happy you edited the thread title...I make an effort to make sure I carefully word my threads so that if I find an answer those who use the same terminology as I do will find my thread and hopefully the an answer too...if only I learn from the answers I get then it's a waste...but if everyone learns...then it makes a forum worth more then something like IRC where everything is seen only by those directly interacting.
Post Reply