|
|
|
|
||||
|
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 |
12-27-2004, 02:56 AM
|
#1 |
|
Registered User
Join Date: Nov 2002
Posts: 77
|
How to import mysql backup?
I backup mysql from the old server and trying to import all the data in the new database on the new server. I'm all over phpMyAdmin and can't find anything there
 |
|
|
|
12-27-2004, 02:57 AM
|
#2 |
|
Confirmed User
Join Date: Nov 2004
Location: Scottsdale, AZ
Posts: 5,167
|
Just copy/paste the SQL code into a huge SQL query
 What export method did u use? |
|
|
|
|
12-27-2004, 02:58 AM
|
#3 |
|
Confirmed User
Join Date: Nov 2004
Location: Scottsdale, AZ
Posts: 5,167
|
Going to sleep. Try what I said
|
|
|
|
|
12-27-2004, 03:03 AM
|
#4 | |
|
Registered User
Join Date: Nov 2002
Posts: 77
|
Quote:
Exported it as SQL and save as File |
|
|
|
|
|
12-27-2004, 03:10 AM
|
#5 |
|
Confirmed User
Join Date: Nov 2004
Location: Scottsdale, AZ
Posts: 5,167
|
Just copy and paste it all into a SQL query in phpMyAdmin
Or with the command line, something like mysql -u xxx db < file.txt Don't remember exactly... Haven't used mysql in a long time |
|
|
|
|
12-27-2004, 04:15 AM
|
#6 |
|
Confirmed User
Join Date: Aug 2001
Location: An Oasis atop a High Desert Mesa
Posts: 386
|
in SSH type:
mysql -u {username} -p -h {hostname} {dbname} < mysqldumpfile.sql or, much more wisely, just paypal me $50 to do it for you. 
__________________
I'm not a porn monger. I'm a porn ... STYLIST! Buildit Cheap, build it Fast, Build it Right. - Pick Two. |
|
|
|
