Thanks to all your hel is really aprecciated and by the way when in mexico
call.
-----Mensaje original-----
De: Bob Page <bpage@w...>
Para: professional php <pro_php@p...>
Fecha: Viernes, 09 de Marzo de 2001 10:25 a.m.
Asunto: [pro_php] RE: how make a duplicate copy of a mysql database ??


>You wrote:
>> Hi Bob Thakns
>> I am working live on my web server since comewith php and mysql
>> preinstalled
>> and iam fairly new to all this my web server is apache on red hat linux,
>> i mainly work vial telnet
>> and login as mysql -u root -p
>> this means as the root user
>> can i do
>> mysqldump mydb > mydb.sql
>
>Well, I think you are confusing logging in to the mysql server which is
>something different from running the mysqldump utility.  You don't login to
>mysql to run mysqldump.  Leonard explained it very well in the previous
>message.  Just do what he suggests from the command prompt:
>
>mysqldump -u root -p [databasename] > [filename.sql]
>
>> do ineed to create de mydb.sql file first do i need to place it in a
>> diferent directory?
>>
>
>What you are doing in the above example is redirecting the output of
>mysqldump to a file name of your choosing.  The name [filename.sql] is
>arbitrary;  whatever you would like to call it.  The file will be created
>for you when you call the mysqldump program (unless of course it already
>exists and then it will be overwritten) and the SQL to recreate the
database
>will fill it up. If you want to have the dump or "copy" placed somewhere
>other than where you currently are when running the program you can specify
>the path as Joel suggests:
>
>mysqldump -u root -p [databasename] >
>[/Jorge/wants/thefile/here/filename.sql]
>
>Of course you will not want to type this with the brackets[].  :)
>
>> please consider that i am 45 and trying to learn this is my first
>> experience
>> thanks
>
>No problem.  I'm 46 and spend most of my day banging my head against the
>wall. The learning never ends.  :)
>
>Take care,
>B.Page
>
>