RE: FN-FORUM MySQL database backup

date posted 12th July 2001 09:57

Mysqldump -u username -p password databasename tablename > tablename.txt

-------------------------
Matt Russell
http://www.i-fire.co.uk
i:fire digital media
-------------------------

> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of Keith Budden
> Sent: 09 July 2001 00:00
> To: [EMAIL REMOVED]
> Subject: RE: FN-FORUM MySQL database backup
>
>
> Willie
>
> Thanks for looking at my latest website.
>
> To answer your question re mysql - if you have telnet access to the
> server it would probably be best for you to run
>
> Mysqldump -u username -p password databasename tablename > tablename.txt
>
> For each table - and then use ftp to transfer the .txt files to your
> local pc. You can then use this file for input on the new server to
> recreate your tables with the same structure and data vis
>
> Mysql -u username -p password databasename < tablename.txt
>
> Or you can do that bit using phpadmin
>
> Alternatively - if you have access to the directory where the mysql data
> files are stored on the remote server and have mysql on your local pc,
> you can download all of the files using ftp and do the mysqldump bit
> locally - it would probably be advisable to stop mysql on the remote
> server while you transferred the files though.
>
> Hope this helps
>
> Keith Budden
> www.conceptadesigns.com
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] On Behalf Of Willie Jordaan
> Sent: 08 July 2001 22:02
> To: [EMAIL REMOVED]
> Subject: FN-FORUM MySQL database backup
>
>
> Real dumb MySQL question.
>
> Would it be possible to download a local copy of MySQL database.
>
> I am thinking of changing hosts and do not want to loose the info
> already on MySQL databases.
>
> I have already installed phpMyAdmin, but am not very familiar with it.
>
> Also, how will I get the info already in these databases onto databases
> created by the new hosting company?
>
> Reading the documentation that comes with this application will take
> years and I am not really sure what to look for.
>
> Any pointers please.
>
> Cheers
>
> Willie
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information
> please visit: http://www.freelancers.net/forum.html
>
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further
> information please visit:
> http://www.freelancers.net/forum.html
>