Moving to dreamhost

I have a large database, anyone knows a good way on how to restore it?

If you are using MySQL and have a sql script resulted from mysqldump, then upload your script to your server via ftp/sftp. Then via ssh you can execute this command :

mysql -u userame -p database < dump_file

Hope it helps.

T-T-L

Here's a whole page on the subject: http://wiki.dreamhost.com/Migrate_MySQL

That Wiki page should help you quite a lot. In fact, it's relatively easy.

||||||||||||||||||||||||||||||||||||||||||||||||||
Check Out

Thanks for the help!!
Guys, if for some reason i can't do it on my own, is anyone willing to give me a helping hand?

In reply to:
Guys, if for some reason i can't do it on my own, is anyone willing to give me a helping hand?

Try to keep posting in the forum first. If there's a slow help, try #dreamhost IRC channel at freenode server.

Dino

You can send a private message to me if you really need help.

||||||||||||||||||||||||||||||||||||||||||||||||||
Check Out

In reply to:
Try to keep posting in the forum first.

That's good advice. It's a classic help desk situation that allows us to team-solve problems and respond more quickly if someone gets busy or goes on vacation. smile We even get to see the whole support log in the forum thread!

Thanks guys!
I made the decision and moved. Now, how do i start moving the files? I didn't changed my DNS on the domains because i only want to do it after everything is moved.

In reply to:
Now, how do i start moving the files?

Maybe you might start by doing these steps :
1. Create a user for your domain through your web panel. If you need to know type of users see it here.
2. As you may want to restore your database using mysql command line, make sure your "Type of User Account" is "Shell".
3. Add new domain/subdomain from the panel with "FTP user / CGI-runs-as user" point to your new user created in step 2.
4. If you leave all the default setting, you usually have "/home/username/yourdomain" folder as your document root.
5. Use ftp client to connect to your server, upload all your web files and of course your mysql backup file.
6. Use ssh client to connect to your server and then restore your mysql. If you do not upload your mysql script (step 5) then try piping mysql as described in wiki.

Hope it helps smile

Dino

found it!

(rolls.dreamhost.com - that was what i was looking for)Edited by rady on 06/29/07 08:37 AM (server time).

Ok, i'm trying to restore a database. I uploaded the backup under the /home/myuser/mydomain directory. I also created the database in which the backup will go, and installed WinSCP on my PC. Can anyone guide me step by step on what to do next? I didn't figure it out yet from the previous replies

Thanks! :D

1. Log in to the shell through SSH. Like almost everyone else in the universe, I use PuTTY.
2. cd to the directory where you put the backup file.
3. Like the wiki article says: issue the following command, substituting for <mysql.example.com>, <sql username>, <sql password>, <newdbname> and <outfile.sql>:
mysql -h <mysql.example.com> -u<username> -p<password> <newdbname> < <outfile.sql>

<mysql.example.com> = the hostname of your sql server
<sql username> = your dbadmin username
<sql password> = your dbadmin password
<newdbname> = the name of your new database
<outfile.sql> = the name of the backup file you just transferred

Let us know if you have any trouble!

Hello guys

My problem is a bit same

I moved and made DNS changes, everything seems ok but, The site sometimes opens with the old server and that drives me crazy. I moved it today and I want to ask if it normal for a few days ?

That's not uncommon for a bit - although once a system resolves the right system it should continue to resolve correctly. But moving between locations may result in different behavior.

Next time you have a question that really is unrelated to the original posting, please make a new post.

Wholly - Use promo code WhollyMindless for full 97$ credit. Let me know if you want something else!

In reply to:
I moved and made DNS changes, everything seems ok but, The site sometimes opens with the old server and that drives me crazy. I moved it today and I want to ask if it normal for a few days ?

Usually it takes a couple of days. So it is normal.

Dino