RE: Using PHP to copy tables

2004-06-18 Thread Michael McTernan
8:36 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Using PHP to copy tables > > > > Is there an easy way to create an HTML page that will copy > selected tables > > to backup copies on the same server? I want to create an administration > > page for my cl

Re: Using PHP to copy tables

2004-04-08 Thread Mark Susol | Ultimate Creative Media
> Is there an easy way to create an HTML page that will copy selected tables > to backup copies on the same server? I want to create an administration > page for my client to be able to "backup" their database whenever they see > fit. But, I can't give them direct access to the MySQL server and don

Re: Using PHP to copy tables

2004-04-08 Thread Mark Susol | Ultimate Creative Media
> Is there an easy way to create an HTML page that will copy selected tables > to backup copies on the same server? I want to create an administration > page for my client to be able to "backup" their database whenever they see > fit. But, I can't give them direct access to the MySQL server and don

Re: Using PHP to copy tables

2004-04-08 Thread Arthur Radulescu
Try using such command from PHP... system("$MYSQLDUMP --opt --user=$USER --password=$PASSWORD $DATABASE_NAME $GZIP - > $BKDIR/$newfile.gz",$status); where $MYSQLDUMP is the mysqldump path $GZIP is the path to gzip $BKDIR is the path to the backup folder

Re: Using PHP to copy tables

2004-04-08 Thread Daniel Clark
Sound like a great idea! > Is there an easy way to create an HTML page that will copy selected tables > to backup copies on the same server? I want to create an administration > page for my client to be able to "backup" their database whenever they see > fit. But, I can't give them direct access

Using PHP to copy tables

2004-04-08 Thread Robb Kerr
Is there an easy way to create an HTML page that will copy selected tables to backup copies on the same server? I want to create an administration page for my client to be able to "backup" their database whenever they see fit. But, I can't give them direct access to the MySQL server and don't want

Re: mysqlhotcopy: doesn't copy tables ??

2002-03-20 Thread ds
Check ownership and permissions of MyDatabase_copy directory (and maybe the files). On Wed, 2002-03-20 at 02:01, Ashwin Kotian wrote: > I'm using the following syntax to backup one of my Mysql databses using > mysqlhotcopy: > > #/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy > > T

mysqlhotcopy: doesn't copy tables ??

2002-03-19 Thread Ashwin Kotian
I'm using the following syntax to backup one of my Mysql databses using mysqlhotcopy: #/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy There is no error message & there is no difference between the two folders /var/lib/mysql/MyDatabase & /var/lib/mysql/MyDatabase_copy when I do a

RE: copy tables to another db

2001-09-25 Thread Nick Willey
Nick > - Original Message - > From: "Jeremy Morano" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, September 25, 2001 4:19 PM > Subject: copy tables to another db > > > > > > > > Hi there I was wondering how to copy tab

Re: copy tables to another db

2001-09-25 Thread Steve Suehring
9/25/01 -0400, Jeremy Morano wrote: >Hi there I was wondering how to copy tables from one db to the another? > >can't find it in the manual... > >- >Before posting, please check: >http://www.mys

copy tables to another db

2001-09-25 Thread Jeremy Morano
Hi there I was wondering how to copy tables from one db to the another? can't find it in the manual... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Copy tables

2001-09-06 Thread Deryck Henson
I dont know if it's me or what but that Manual is driving me crazy just searching! I cant find out how to copy a table and rename it at the same time. pls help - Deryck H - http://www.comp-u-exchange.com - Before posting, ple