Dillon, John wrote:
[from a post by Jon Benson on http://www.mysql.com/doc/en/mysqldump.html]
It worries me that --opt includes a add-drop-table command. Since it is
creating a new file, how does this affect anything. I just don't want to
delete anything. Is it relevant on restoring only?
Do yo
Hi Richard,
> I simply login to my server and issue a command like:
> mysqldump -hmysqlserverhost.com -utheusername -p dbname >
dbname.sql
> It will then prompt me for my password and dump the database (dbname)
into dbname.sql
> -h = the sql host (often localhost)
> -u = a mysql account that ha
Hi Richard,
> I simply login to my server and issue a command like:
I think that's the bit I missed. I've managed to create the database-d web
site (and live happily) without ever logging in to a shell-type area. I've
begun to use Putty/SSH as Leech doesn't show me a shell to type commands to
Hello John,
Thursday, December 4, 2003, 11:01:20 AM, you wrote:
DJ> The question is how do people out there
DJ> back up their database residing on a server to a local file? Ideally I would
DJ> download the database and save on a CD, and be able to restore from this if
DJ> the worst happened.
Per
I use Mascon from scibit to view my database. It has a dump facility to
dump to another database or to a local file. I am afraid of the first
option lest it overwrites tables already on the other server. When I dump
to a local file it is a text file and I can't work out how I would restore
from