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 h
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" wrote:
>
> I created a VIEW “table” yesterday. Last night when the cron job ran to
back up the database I received this error:
>
>
> mysqldump: Cou
e
Date: Wednesday, December 10, 2008 09:25:37 PM -0600
From: phphelp -- kbk
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 Windo
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
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 dumpin
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 th
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 creat
al Message -
From: "Ken Kixmoeller.com" <[EMAIL PROTECTED]>
To:
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,
Merci, Yves - --
It takes the blink of an eye. It seems like none of the string is
running at all.
Also, yeah, the slashes thing used to trip me up, too, when I first
started working around Linux boxes. However, the file *is* being
created and it is in the right place, just nothing in it.
Hi Ken,
How long does the mysqldump operation last? Maybe it's a script timeout
problem? And maybe you have different settings on both machines?
Other idea: what about pathnames? Linux uses "/" to separate paths, Windows
uses "\".
That's all I have for now,
Yves
- Original Message --
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
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
why no use phpmyadmin to admin the db?
Bastien
From: Jeffrey <[EMAIL PROTECTED]>
To: PHP DB
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 the data to a file an
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 mysqldump
[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... interesting..
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 tab
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 th
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:
exec("/usr/local/mysql-standard-4.1.7-apple-darwin7.5.0-p
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
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.
Sp
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 = "/home/virtual/site
On Tuesday 09 November 2004 17:59, Aaron Todd wrote:
> I have created a PHP script that looks like:
>
>$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.
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:
$filename');
?>
For some reason this doesnt work and I cant fig
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
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:
$filename');
?>
For some reason this doesnt work and I cant figure out why. There is
no
error that comes back. When I run
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
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 u
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
28 matches
Mail list logo