Dear List -
I am using the following command:
mysqldump -u root -p Store StoreBkup.sql;
to backup the database called Store.
Mysql insists on giving a syntax error.
Advice and help, please.
Thanks.
Ethan
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Wed, Jan 2, 2013 at 12:50 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I am using the following command:
mysqldump -u root -p Store StoreBkup.sql;
to backup the database called Store.
Mysql insists on giving a syntax error.
Advice and help, please.
I created a VIEW “table” yesterday. Last night when the cron job ran to back
up the database I received this error:
mysqldump: Couldn't execute 'show create table
`bible_anagrams_rss_feed_summary`': SHOW VIEW command denied to user
I use the following syntax to do the backup of the
Give the user show view permission
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_show-view
On 06/06/2011 7:57 AM, Ron Piggott ron.pigg...@actsministries.org wrote:
I created a VIEW “table” yesterday. Last night when the cron job ran to
back up the database I received this
-- kbk phph...@comcast.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQLDump through PHP/HTML UI
Hi, Chris -- -- -- --
Yes, thanks for the suggestion: it runs from the command line just
fine. I run them often, and it works in Windows.
However, I just was able to gain access again to the error
Hello - - -- -
I have a utility which creates a MySQLDump of selected tables or the
whole database. This works fine on my development machine, a W2K
box. It does not work on the testing server, a linux box.
I'll post code if you want, but it is very simple:
1. I create the dump language,
-
From: phphelp -- kbk [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Wednesday, December 10, 2008 9:32 AM
Subject: [PHP-DB] MySQLDump through PHP/HTML UI
Hello - - -- -
I have a utility which creates a MySQLDump of selected tables or the
whole database. This works fine on my development
\.
That's all I have for now,
Yves
- Original Message - From: phphelp -- kbk
[EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Wednesday, December 10, 2008 9:32 AM
Subject: [PHP-DB] MySQLDump through PHP/HTML UI
Hello - - -- -
I have a utility which creates a MySQLDump of selected tables
-
From: Ken Kixmoeller.com [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Wednesday, December 10, 2008 11:38 AM
Subject: Re: [PHP-DB] MySQLDump through PHP/HTML UI
Merci, Yves - --
It takes the blink of an eye. It seems like none of the string is running
at all.
Also, yeah
phphelp -- kbk wrote:
Hello - - -- -
I have a utility which creates a MySQLDump of selected tables or the
whole database. This works fine on my development machine, a W2K box.
It does not work on the testing server, a linux box.
I'll post code if you want, but it is very simple:
1. I
Hi, Chris -- -- -- --
Yes, thanks for the suggestion: it runs from the command line just
fine. I run them often, and it works in Windows.
However, I just was able to gain access again to the error log (long
story), and I see that the page is throwing an unrelated error that
it does not
On Dec 10, 2008, at 3:21 PM, Yves Sucaet wrote:
What PHP-function/command are you using to invoke the mysqldump
command?
As I said in the original post, I have used both system() and exec(),
both with the same result.
Try including a flush() statement right before you start
phphelp -- kbk wrote:
Hi, Chris -- -- -- --
Yes, thanks for the suggestion: it runs from the command line just fine.
I run them often, and it works in Windows.
However, I just was able to gain access again to the error log (long
story), and I see that the page is throwing an unrelated error
Thanks all for the help!
exec() seems the best option.
Jeffrey
Miguel Guirao wrote:
You could use exec() within PHP!
-Original Message-
From: Adrian Bruce [mailto:[EMAIL PROTECTED]
Sent: Jueves, 29 de Junio de 2006 06:31 a.m.
To: Jeffrey
Cc: PHP DB
Subject: Re: [PHP-DB] mysqldump
I would like to do a backup of an entire MySQL database via php. My
thought was to use mysqldump, write the data to a file and save the
file. However...
$query=mysqldump $dbase;
$result=mysql_query($query) or die(mysql_error());
...immediately results in an error in your SQL
mysqldump is a .exe, and therefore it will not work within mysql_query();
You may be able to use mysqldump from PHP using the system function
check out http://uk.php.net/system
Ade
Jeffrey wrote:
I would like to do a backup of an entire MySQL database via php. My
thought was to use
why no use phpmyadmin to admin the db?
Bastien
From: Jeffrey [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] mysqldump via php
Date: Thu, 29 Jun 2006 12:38:51 +0200
I would like to do a backup of an entire MySQL database via php. My thought
was to use mysqldump, write
You could use exec() within PHP!
-Original Message-
From: Adrian Bruce [mailto:[EMAIL PROTECTED]
Sent: Jueves, 29 de Junio de 2006 06:31 a.m.
To: Jeffrey
Cc: PHP DB
Subject: Re: [PHP-DB] mysqldump via php
mysqldump is a .exe, and therefore it will not work within mysql_query();
You
Hello everyone,
I've a reader for sometime now, the best db list ever got into.
Well, I'd like to mysqldump a certain database, but with skipping one table, is
it possible?
Thanx
-
Yahoo! Mail
Stay connected, organized, and protected. Take
Hassan wrote:
Hello everyone,
I've a reader for sometime now, the best db list ever got into.
Well, I'd like to mysqldump a certain database, but with skipping one table, is it possible?
[snip]
from mysqldump --help
--ignore-table=name
Do not dump the specified table. To specify more
C:\mysqldump --version
mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32)
C:\mysqldump --help | grep table
STDIN 6 Dumping definition and data mysql database or table
STDIN 7 Usage: mysqldump [OPTIONS] database [tables]
STDIN 22--add-drop-tableAdd a 'drop
[EMAIL PROTECTED] wrote:
C:\mysqldump --version
mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32)
[snip]
Ummm. What version are you using, Martin?
David
fairly fresh I'm afraid.
mysqldump Ver 10.9 Distrib 4.1.9, for pc-linux-gnu (i686)
your grep generates...
Wonder if anyone out there can help?
I'm trying to execute a mysql dump on my local Mac (running 10.4),
and I'm running into an odd problem, possibly something to do with
permissions or $PATH setup.
Here's the code...
?php
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'blah';
On 10 May 2005, at 07:24, Constantin Brinzoi wrote:
maybe you have to specify the full path to mysqldump like:
passthru(/path/to/mysqldump --opt -h$dbhost -u$dbuser -p$dbpass
$dbname
It was worth a try - but no, changing the exec line to:
Hi,
Look at this page and you will get all the answers
http://www.geeklog.net/samplecode/backup-database
regards
vimal.v([EMAIL PROTECTED])
David Orlovich wrote:
also ... I notice you have a space after the -u - should that be
there? David.
On 10/11/2004, at 6:59 AM, Aaron Todd wrote:
I have
I have created a PHP script that looks like:
?php
$filename = /var/www/html/db_backup_ . date(n-j-y)..sql;
exec('mysqldump -u * -p* database $filename');
?
For some reason this doesnt work and I cant figure out why. There is no
error that comes back. When I run the mysqldump
I wonder if you need to specify the full pathname for mysqldump - when
it's being executed by a script it may not know where mysqldump is,
whereas if you execute it yourself your PATH tells it where to go,
which might be why it works under that circumstance. HTH, David.
On 10/11/2004, at 6:59
also ... I notice you have a space after the -u - should that be
there? David.
On 10/11/2004, at 6:59 AM, Aaron Todd wrote:
I have created a PHP script that looks like:
?php
$filename = /var/www/html/db_backup_ . date(n-j-y)..sql;
exec('mysqldump -u * -p* database $filename');
?
As far as I know...yes. Thats what I have seen on every post I have looked
at and also, thats the way it worked from the console. It wouldnt work with
no space.
Thanks for your reply,
Aaron
David Orlovich [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
also ... I notice you
Does that user have permissions to run the mysql dump ?
Bastien
From: Aaron Todd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysqldump
Date: Tue, 9 Nov 2004 12:59:31 -0500
I have created a PHP script that looks like:
?php
$filename = /var/www/html/db_backup_ . date(n-j-y)..sql
On Tuesday 09 November 2004 17:59, Aaron Todd wrote:
I have created a PHP script that looks like:
?php
$filename = /var/www/html/db_backup_ . date(n-j-y)..sql;
exec('mysqldump -u * -p* database $filename');
?
For some reason this doesnt work and I cant figure out why. There
Jason,
I tried the double quotes but that didn't seem to matter. I also put the
command string in a variable and then am running the variable with exec.
Still it doesnt work.
$filename = /home/virtual/site341/fst/var/www/html/db_backup_ .
date(n-j-y)..sql;
$command =
On Tuesday 09 November 2004 19:12, Aaron Todd wrote:
Please do not top post (google top post).
I tried the double quotes but that didn't seem to matter.
It does matter.
I also put the
command string in a variable and then am running the variable with exec.
Still it doesnt work.
Hi,
Can you show the code? How r u running mysqldump in your php code? I
think phpmyadmin has such facility as well, you may want to check their
code and see how they did it ...
Gurhan
On Sat, 2003-05-31 at 06:51, buttoz wrote:
hi,
i want to backup mysql database.
i use mysqldump command .
Hi buttoz
Here's how I did it ...
function get_script($dbname) {
$cmd = /usr/bin/mysqldump -u._DBUSER. -p._DBPASS. ._MDFLAGS. .$dbname;
$script = `$cmd`;
return $script;
}
_MDFLAGS is a constant which holds the flags you want to pass to mysqldump ... I
commonly use -c
hi,
i want to backup mysql database.
i use mysqldump command .
when i use this command from server (win2000) , command promt its work fine.
but when run this command (mysqldump) from php file, it creat backup file
but
with zero size.
what can i do , help me?
thanks,
zuhear
--
PHP Database
36 matches
Mail list logo
