from a command prompt mysqldump -opt database >dumpfile
Curtis
On Sunday 08 June 2003 02:59, JeRRy wrote:
> Okay thanks.
>
> One last thing.
>
> From the mysql prompt how can I generate a database
> backup? (So I can see the database setup in notepad
> so I can backup and transfer easily online
At 18:40 +1000 6/8/03, JeRRy wrote:
Hi,
I downloaded the Windows version of mysql. And just
set it up but currently it works as root and no
password. Not a real concern as I shut down the mysql
as I finish working as I use it offline. But I would
like to setup the user account and password as I
At 16:59 +1000 6/8/03, JeRRy wrote:
Okay thanks.
One last thing.
From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
Not from the mysql prompt. You want to use the mysqldump
program.
Jerry
--
Paul
Hi,
I downloaded the Windows version of mysql. And just
set it up but currently it works as root and no
password. Not a real concern as I shut down the mysql
as I finish working as I use it offline. But I would
like to setup the user account and password as I have
it on my web server so it's ea
Okay thanks.
One last thing.
>From the mysql prompt how can I generate a database
backup? (So I can see the database setup in notepad
so I can backup and transfer easily online.)
Jerry
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text
Thanks, worked nicely.
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text file with all my database information
> to
> >create databases to setting up tables. I have
> looked
> >throught the mysql docs onto how to load these on
> from
> >
At 14:52 +1000 6/8/03, JeRRy wrote:
Hi,
I have a text file with all my database information to
create databases to setting up tables. I have looked
throught the mysql docs onto how to load these on from
the mysql prompt. But all I can find is:
load data infile "filename.txt" into table whatever
Greetings
If you are on Windows then you can try out SQLyog at
http://www.webyog.com/sqlyog . It has GUI interface
for many ways to import data in MySQL whether CSV, SQL
Batch file etc.
Karam
--- JeRRy <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a text file with all my database information
> to
Hi,
I have a text file with all my database information to
create databases to setting up tables. I have looked
throught the mysql docs onto how to load these on from
the mysql prompt. But all I can find is:
load data infile "filename.txt" into table whatever
But this is not what I am looking
