Transfering Database  | | | 
July 18th, 2003, 03:14 AM
|
#1 (permalink)
| | Member
Join Date: Jun 2003
Posts: 99
|
I have recently moved servers and my forum is the best part of my site. I downloaded my database and tried to import it into my new database through php my admin and it ends up timing out or something and comes up with action canceled. The database is 20 megs big and I really need it to get to my new server or I lose everything good about my site. | 
|  | |
July 18th, 2003, 03:19 AM
|
#2 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,385
|
what kind of database are you coming from?
Are you using teh same kind of database on the way in?
Username/password ok?
Has permissions?
Mysql to mysql?
are you trying to import a file from a remote location?
__________________
Helicopters don't fly; they vibrate so much and make so much noise that the earth rejects them.
| |
| | |
July 18th, 2003, 03:21 AM
|
#3 (permalink)
| | Member
Join Date: Jun 2003
Posts: 99
|
MySQL to MySQL. User and pass is all correct im doing it from my pc to my server not a personal server but from a host. | |
| | |
July 18th, 2003, 03:28 AM
|
#4 (permalink)
| | Not Really a Member
Join Date: Oct 2001
Posts: 25,385
|
Is the database file local, or is it already on the server?
MySQL services are started correctly?
There is disk space on the host server? (would hope so, or its a pretty crappy host!) | |
| | |
July 18th, 2003, 03:32 AM
|
#5 (permalink)
| | Member
Join Date: Jun 2003
Posts: 99
|
Everything is running and ts local and yeah theres a ton of space left on it. | |
| | |
July 18th, 2003, 03:52 AM
|
#6 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Sweden
Posts: 1,748
|
I would try uploading it before importing it, if you haven't done that. | |
| | |
July 18th, 2003, 04:00 AM
|
#7 (permalink)
| | Member
Join Date: Jun 2003
Posts: 99
|
I wouldnt know how I think... I downloaded it from one host and and want to put it on another host. I made a database and its emtpy and theres that option where I can locate a sql file and upload it or something thats what Im trying to do or is there some other way to do it? | |
| | |
July 18th, 2003, 04:38 AM
|
#8 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Arizona
Posts: 2,538
|
Figure out where your home dir is on the box..and run this SQL query.
source /path/to/home/dir/filename.sql <-- Exported file.
You should be able to run that from your nice SQL query whitebox in phpMyAdmin.
Last edited by Praetorian : July 18th, 2003 at 04:41 AM.
| |
| | |
July 18th, 2003, 05:27 AM
|
#9 (permalink)
| | Member
Join Date: Jun 2003
Posts: 99
|
It came up with an error. A syntax error within the file at line one.
Last edited by SplitCo : July 18th, 2003 at 05:32 AM.
| |
| | |
July 18th, 2003, 11:44 AM
|
#10 (permalink)
| | Ultimate Member
Join Date: Oct 2001 Location: Arizona
Posts: 2,538
|
You only typed what i put in bold, right? You may have to terminate the line with a semi-colon ";". | |
| | | Thread Tools | Search this Thread | | | | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Most Active Discussions  | | | | |   Recent Discussions  | | | | |
 |
hardware
prices 
