Re: FN-FORUM MySQL database backup

date posted 12th July 2001 10:28

cheers all...that's sorted!!!

Robin Garbutt
Portfolio Art & Design Ltd
Tel - +44 (0) 1204 383822
Fax - +44 (0) 1204 383866
Mob - +44 (0) 7811 185490
e-mail - [EMAIL REMOVED]

For further information please visit us at :-
www.portfoliodesign.net

The contents of this e-mail are confidential to the ordinary user of the
e-mail address to which it was addressed and may also be privileged. If you
are not the addressee of this e-mail you may not copy, forward, disclose or
otherwise use it or any part of it in any form whatsoever. If you have
received this e-mail in error please e-mail the sender.

----- Original Message -----
From: "Matt Russell" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, July 12, 2001 9:58 AM
Subject: RE: FN-FORUM MySQL database backup


> 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
> >
>
>
> ============================================================
>
> * 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
>