Restoring Issue

H

hostersuk

Verified User
Joined
Jan 22, 2006
Messages
5
Location
Staffordshire, UK
Hello DirectAdmin,

I've recently switched over from using CPanel for 2years to DirectAdmin. I've moved afew clients from "Server #2" and im having trouble uploading the SQL Database to "Server #3"

Using the upload SQL to database, via the DirectAdmin control panel.

Can you somebody give me an hand or advice.

Many Thanks,
 
Well, what I usually do is simply copy the database files themselves directly from one server to the other (on my server they are located in /var/lib/mysql/username). I know this isn't exactly how it's supposed to be done, but it works for me (of course both servers are running the same mysql version).
Maybe it would work for you to?
 
Last edited:
Aspegic said:
Well, what I usually do is simply copy the database files themselves directly from one server to the other (on my server they are located in /var/lib/mysql/username). I know this isn't exactly how it's supposed to be done, but it works for me (of course both servers are running the same mysql version).
Click to expand...
Aspegic, do you change the database names to the DA style?

If so, does it cause you any problems?

If not, does it cause you any problems?

Jeff
 
The database names are dfferent on both servers (username_data and db_username), but I don't copy folders, I only copy files so I it doesn't matter.

I copy the .frm .MYD and .MYI files back and forth all the time. I must have done it several hundreds of times by now and I have never encountered any problems.
I also copy them directly to my windows developer pc (which is also running apache/php/mysql) and it works there to.
 
Last edited:
On my server they are in /var/lib/mysql/username

But maybe different distros store them in different folders, I don't know. Try a search for *.MYD. Maybe you can find them that way. They must be somewhere :)
 
You must log in or register to reply here.
Back
Top