|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
02-05-2004, 07:51 PM
|
#1 |
|
Registered User
Join Date: Jan 2004
Location: Canada
Posts: 82
|
MySql Database Help Please
I have a backup of my database and I need to restore it to a new MySql DB on another server. All of the Tables are already created and I dont' want to dump and recreate the DB. I just want to populate the new DB with the old DB's info.
Any help would greatly appreciated. 
__________________
 When the tailgate drops, the bullshit stops |
|
|
|
02-05-2004, 07:52 PM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Mar 2003
Location: ::::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::||||||||||||:::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::::::::::::::::::::
Posts: 7,197
|
you got SSH access?
__________________
Amen |
|
|
|
|
02-05-2004, 07:53 PM
|
#3 | |
|
Confirmed User
Join Date: Aug 2003
Location: Portland, Oregon
Posts: 4,541
|
Quote:
__________________
Real. Professional. Hosting. .:Expect Nothing Less:. 320-078-843 :: www.realprohosting.com :: [email protected] |
|
|
|
|
|
02-05-2004, 07:55 PM
|
#4 |
|
Registered User
Join Date: Jan 2004
Location: Canada
Posts: 82
|
Yes, ssh
__________________
When the tailgate drops, the bullshit stops |
|
|
|
|
02-05-2004, 07:56 PM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Mar 2003
Location: ::::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::||||||||||||:::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::::::::::::::::::::
Posts: 7,197
|
mysql -uUSERNAME -p dbname < /path/to/dump.sql
this script will work too but the above command is easier http://www.ozerov.de/bigdump.php
__________________
Amen |
|
|
|
|
02-05-2004, 07:58 PM
|
#6 |
|
Registered User
Join Date: Jan 2004
Location: Canada
Posts: 82
|
Yes but when I do that command it says the table has already been created which it has. I'm worried about breaking something in the software that connects to it and would prefer to just insert the data from the old backup.
__________________
When the tailgate drops, the bullshit stops |
|
|
|
|
02-05-2004, 08:00 PM
|
#7 |
|
Confirmed User
Join Date: Nov 2002
Posts: 7,761
|
How did you backup the old database?
|
|
|
|
|
02-05-2004, 08:01 PM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Mar 2003
Location: ::::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::||||||||||||:::::: :::::::::::||::::::::::: :::::::::::||::::::::::: ::::::::::::::::::::::::
Posts: 7,197
|
Well I would just rename the database you have there now then recreate it. Becasue hte backup you have is always going to try to recreate the tables unless you go in with a txt editor and remove all the table creation statments.
I highly doubt an unavialbe databse would "Break" any scripts.
__________________
Amen |
|
|
|
|
02-05-2004, 08:01 PM
|
#9 |
|
Registered User
Join Date: Jan 2004
Location: Canada
Posts: 82
|
I just dumped it. no special flags, maybe I'm just going to have to drop all the tables in the new DB and restore it.
__________________
When the tailgate drops, the bullshit stops |
|
|
|
|
02-05-2004, 08:03 PM
|
#10 |
|
Registered User
Join Date: Jan 2004
Location: Canada
Posts: 82
|
Ok, thanks gusy. I'll backup this one restore the old one and see what happens. It should be fine.
Thanks for jumping in and helping me so quickly. You guys are too cool. 
__________________
When the tailgate drops, the bullshit stops |
|
|
|
