Moving to dreamhost


#1

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


#2

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
$97 off using [color=#CC0000]LuckyYou[/color] promo code (Just $22.40/1st year with Crazy Domain Insane plan) :cool: . Sign Up NOW


#3

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


:stuck_out_tongue: Save up to $96 at Dreamhost with ALMOST97 promo code (I get $1).
Or save $97 with THEFULL97.


#4

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

||||||||||||||||||||||||||||||||||||||||||||||||||
Check Out DreamHost Promo Codes


#5

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?


#6

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

Dino

Get YOUR $97 off on yearly plan with [color=#CC0000]YOUGET97 [/color] promo code. Sign Up NOW


#7

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

||||||||||||||||||||||||||||||||||||||||||||||||||
Check Out DreamHost Promo Codes


#8

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. :slight_smile: We even get to see the whole support log in the forum thread!

Free unique IP and $67 off with promo code [color=#CC0000]FLENSFREEIP67[/color] or use [color=#CC0000]FLENS97[/color] for $97 off. Click here for more options


#9

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.


#10

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 :slight_smile:

Dino
Get YOUR $97 off on yearly plan with [color=#CC0000]YOUGET97 [/color] promo code. Sign Up NOW


#11

found it!

(rolls.dreamhost.com - that was what i was looking for)


#12

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! :smiley:


#13
  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>, , , and <outfile.sql>:
    mysql -h <mysql.example.com> -u -p < <outfile.sql>

<mysql.example.com> = the hostname of your sql server
= your dbadmin username
= your dbadmin password
= 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!

Free unique IP and $67 off with promo code [color=#CC0000]FLENSFREEIP67[/color] or use [color=#CC0000]FLENS97[/color] for $97 off. Click here for more options


#14

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 ?


#15

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!


#16

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

Dino
Get YOUR $97 off on yearly plan with [color=#CC0000]YOUGET97 [/color] promo code. Sign Up NOW