SQL management tool?


#1

Howdy all. Just moving over here from another host, and I am trying to bring my WordPress and phpBB with me. Following phpBB’s restore instructions (http://www.phpbb.com/kb/article.php?article_id=212) , it says I need to use whatever SQL management tool we have…well…I can’t figure out where it is! Could someone point me to where I need to go in the control panel? I can not find it for the life of me!

Thanks in advance. And if anyone has pointers on moving both of these items, please feel free to share!


#2

when you set up your database, you created a host name - put that into your internet Browser and it will bring up phpmyadmin - the mysql management tool.

You’ll need to log on with the user/pass associated with the database.

-Matttail


#3

In case you’re not familiar with phpMyAdmin, you just have to select “SQL” and then “Import Files” in order to restore your backups.


[color=#000000]DreamHost Promo Code[/color]: [color=#CC0000]Save $50[/color] with the promo code DREAMTEAM


#4

Matttail -

Thank you for your reply. Is this “mysql.mydomain.com” what you mean? Sorry to seem so confused, Dreamhost just seems to be set up very differently than any other hose I have worked with before. I am sure I will get the hang of it.

Sean


#5

From my previous host, I have the MySQL backup files in the format *.frm *.myi and *.myd

PHPmyAdmin does not seem to import these file types. I have installed putty as an SSH client

How do I import these files into my database?


#6

ya, mysql.mydomain.com - the “host name” you typed in when you created the Database.

-Matttail


#7

The easiest thing to do would be to get access to the original database, and get a real mysql export, so you get a *.sql file. (you need to use an export feature, not just copy the files from the mysql database.)

If this is not a possibility you’ll have to contact support and see if they can manually put the files in for you. I found this that tells how to get thoes files into the database. (customers dont’ have appropiate access to the mysql servers to do this)

-Matttail


#8

The previous hosts suspended the account which stops all use of any tools, including PHPmyAdmin.

I was not happy that the previous hosts (Aplus.net) could only give me my website in the form of very large gzipped files ftped to me.

I’ll talk to the support here and see what they can do.


#9

If support can’t help you out, and you’re desperate for the data, PM me and I might be able to help you out. I’m working on getting a debian server running on my computer…

-Matttail


#10

Matttail -

Thank you for your help! It looks like everything is installed correctly, will find out for sure shortly. phew Not something I ever want to do again!

Sean


#11

Ack! Why didn’t I think of it before! One of my friends was actually questioning me the other day as to why I’m not running an Apache Webserver on my computer - seeing as I do so much PHP scripting.

I should set it up on my computer, then export it as text…
Stupid me!