Restoring Issue

[hostersuk]

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,

[Aspegic]

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?

[hostersuk]

I'll give it a whirl in a moment and let you know how i went on.

Thanks for your help mate.

[nobaloney]

Originally posted by Aspegic
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).
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

[Aspegic]

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.

[hostersuk]

I dont have the /lib/mysql folders

:/

[Aspegic]

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

[hostersuk]

Ok mate.

Thanks for your help, will give it a whirl