#1873 - 07/24/0607:18 PMRe: Requirements for version 7
[Re: Daryl Fawcett]
Gizmo
Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
If you have shell access and want to do it yourself: MySQL Export: mysqldump -uusername -ppassword databasename > databasename.sql MySQL Import: mysql -h localhost -uusername -ppassword databasename < databasename.sql
You'd export from mysql on the current machine, send the file to the other machine then import.
#1879 - 07/24/0609:44 PMRe: Requirements for version 7
[Re: Daryl Fawcett]
Gizmo
Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
myself, I'd mysql export, then tar up the file, then transfer, then untar, then mysql import; by tarring the file before you transfer you'll save yourself time, especially if you end up downloading it locally to transfer
tar is a unix command to combine multiple files into one archive, with the option to compress the file. It is like a zip file for windows, or a sit file for macs.
I was told by one of my service provider technicians that I can do a site download into my own computer that will automatically also include the database all in a tar WinRar type file. I can then restore it into the new server.
#3195 - 09/11/0607:30 PMRe: Requirements for version 7
[Re: ]
Gizmo
Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Some of the utilities provided by some control panels are worthless, I used to work for a webhost that used Ensim and I completley dispised the ensim backups, they almost always errored out and hardly ever created a full backup...