Re: I haven't any hair left - Moving an MySQL DB from one server to another...
| From: | Philip Olson | Date: | Fri, 05 Jan 2001 07:38:29 +0000 |
| Subject: | Re: I haven't any hair left - Moving an MySQL DB from one server to another... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-32842@lists.php.net to get a copy of this message | ||
Try mysqldump.
Without compression :
Export : mysqldump -uUsername -p dbname > dbname.sql
Import : mysql -uUsername -p dbname < dbname.sql
Or with compression :
Export : mysqldump -uUsername -p dbname | gzip > dbname.gz
Import : gunzip < dbname.gz | mysql -uUsername -p dbname
This being from the command line.
Regards,
Philip Olson
http://www.cornado.com/
On Fri, 5 Jan 2001, David Smith wrote:
>
> I have purchased a dedicated server and I am trying to download my current
> DB from a hosting company and upload it to my new dedicated server. I have
> MySQLAdmin and it's an awesome program but continuosly getting errors trying
> to import with the querys it displays to import to the new DB. Anyone help
> me here? I have telnet to both servers...
>
>
> Thanks...
>
> David Smith
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>