matt_lists wrote:
I've seen this quite a few times, but never been able to reproduce it
properly.
I'm assuming you're running on Windows, correct?
I'd search your dump-file for DATA DIRECTORY the problem on Windows
is that
it uses \ instead of / in the path names there, which makes it use it
as
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts this
on a couple tables, not all of them
--
MySQL
matt_lists wrote:
Found the problem
now we have this added on a few tables in the dump
DATA DIRECTORY='E:\mysql\data\campbell\' INDEX
DIRECTORY='E:\mysql\data\campbell\'
the restore barfs on this
not sure how to remove this, looking at options now, it only puts this
on a couple tables, not all
On Thu, 27 Jan 2005, matt_lists wrote:
Having repeatable problems doing restores, 4.1.8 and 4.1.9 both do the
same error
Is there some setting I'm missing?
mysqldump -u username-pPassword --all-databases --quote-names
/intranet/backup/backup.sql
E:\intranet\backupmysql -u xotech
This could be a case where your dump files are not split in such a way so
that they honor the max_packet_length setting of the recieving server.
Make sure you tell mysql dump what the maximum size of an INSERT statement
will be for the server you want to read the dump into or it will put all
Hi Tait,
Have you tried show databases to make sure that user can actually use
that database?
mysqlshow databases;
That will tell you if that user has access as it won't show up in the
listing. They may well be able to log into mysql but can they actually
access that database is more the
/2005 01:13 PM
To
Tait Sanders [EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
RE: mysqldump access denied error
Hi Tait,
Have you tried show databases to make sure that user can actually use
that database?
mysqlshow databases;
That will tell you if that user has access as it won't show
From: Tait Sanders [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 January 2005 1:47 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: mysqldump access denied error
yes the user can see the databases with 'show databases;'
I was thinking that there might
- Adelaide) [EMAIL PROTECTED]
18/01/2005 01:23 PM
To
Tait Sanders [EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
RE: mysqldump access denied error
Check that the user has FILE privileges, given that a SELECT ... INTO
OUTFILE sounds awfully like a mysqldump :-
The FILE privilege gives you
Hello.
Try '--open-files-limit=8192' at least. Check the real value of
open_file_limits with such statement:
show variables like '%open_f%';
You can find some recommendations for SuSe Linux at:
http://dev.mysql.com/doc/mysql/en/Linux-post-install.html
Mysql user [EMAIL PROTECTED]
Yep, that seems to have done it, at least when I'm testing it. I'm
pretty sure the problem is fixed, but the next couple of days of
automated backups will tell.
Thanks!
On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote:
Hello.
Try '--open-files-limit=8192' at least. Check the real value of
Hello.
You may execute SET FOREIGN_KEY_CHECKS=0; in mysql and then use
source sql.file;. Run mysql with -B command line option.
Terence [EMAIL PROTECTED] wrote:
Hi,
After reading the docs I realise that in order to use mysqldump with
innodb tables i need to include
SET
Terence,
- Original Message -
From: Terence [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 22, 2004 5:58 AM
Subject: mysqldump and innodb - set foreign_key_checks=0
Hi,
After reading the docs I realise that in order to use mysqldump with
innodb tables i
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 8:15 PM
To: mysql@lists.mysql.com
Subject: Re: mysqldump and innodb - set foreign_key_checks=0
Terence,
- Original Message -
From: Terence [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 22, 2004 5
Hello.
Usually clients are blocked with insert or update statements until
table became unlocked. Their threads just sleep and then continue
execution (but they can got an error if query doesn't return for a long time).
INSERT queries are not buffered in that sense you've ment, unlike they are
At 11:19 +0900 12/13/04, ManojSW wrote:
Hi,
I am running MySQL (4.0.15 max log) mysqldump (version 9.09 Distrib
4.0.16) on Linux platform.
For some strange reasons, I am unable to use the debug option with
mysqldump. I have tried the following switch with no luck:
-# ,
--debug,
PROTECTED]
To: ManojSW [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, December 13, 2004 11:29 AM
Subject: Re: mysqldump + debug option not working
At 11:19 +0900 12/13/04, ManojSW wrote:
Hi,
I am running MySQL (4.0.15 max log) mysqldump (version 9.09
Distrib
4.0.16) on Linux platform
, December 13, 2004 11:29 AM
Subject: Re: mysqldump + debug option not working
At 11:19 +0900 12/13/04, ManojSW wrote:
Hi,
I am running MySQL (4.0.15 max log) mysqldump (version 9.09
Distrib
4.0.16) on Linux platform.
For some strange reasons, I am unable to use the debug option
Hi,
Now I found this line the MySQL Manual:
If you run mysqldump without the --quick or --opt option, mysqldump will
load the whole result set into memory before dumping the result. This will
probably be a problem if you are dumping a big database. As of MySQL
4.1, --opt is on by default, but
-Original Message-
From: Josh Howe [mailto:[EMAIL PROTECTED]
Sent: November 1, 2004 12:31 PM
To: [EMAIL PROTECTED]
Subject: mysqldump
Hi,
Can anybody help me with a linux newbie question. I want to
use mysqldump to backup all of the tables in a database that
Howe
Subject: Re: mysqldump
Take a look at this article:
http://www.unixreview.com/documents/s=8989/ur0408d/
There's a section on mysqldump if you prefer using it. You would do
something like the following to backup only certain tables based on
their names starting with z_.
mysqldump -u root -p
-Original Message-
From: Josh Howe [mailto:[EMAIL PROTECTED]
Sent: November 2, 2004 11:47 AM
To: Spenser; [EMAIL PROTECTED]
Subject: RE: mysqldump
Thanks Spenser, but I'd already tried something similar. What
I get when I try this is:
mysqldump: Can't get CREATE TABLE for table
, 2004 1:44 PM
To: 'Josh Howe'; [EMAIL PROTECTED]
Subject: RE: mysqldump
Did you try this one? I simplified it for you. You just need to put this
in
a file and chmod +x the file. Then you can execute it from a crontab or
with
the shell.
~~~ Copy/paste after this ~~~
#!/bin/bash
# Modify
On 28 Oct 2004, at 12:48, Anil Doppalapudi wrote:
mysqldump running very slow. what might be the reason
[...]
I don't have specific knowledge of your database, so our answers will
be quite vague, but :
Try running with --opt. This produces a less readable outfile, but
produces one much more
Hi.
There are too many things to consider: the size of the table, the load average
of the server, the MySQL configuration, etc. If you could provide us with
much more details - we could check it out and make a guess what's the
bottleneck. Still, anyway you will probably need to optimize your
You won't get any reasonable answers like this. How big is your db? How long
does mysqldump actually take? If you tell this, people can tell you if this
is like expected or too slow. Good answers depend on good questions.
But a hint: You can't expect mysqldump to run in fractions of seconds.
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 8:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysqldump very slow
You won't get any reasonable answers like this. How big is your db? How long
does mysqldump actually take? If you tell this, people can tell you if this
is like expected or too slow
At 15:47 -0400 10/27/04, Michael Ragsdale wrote:
Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
mysqldump: ERROR: unknown variable 'local-infile=1'
I tried using --force and it didn't help.
Showing the variables, I get
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
and upgrade to the latest stable release.
Michael Ragsdale [EMAIL PROTECTED] wrote:
Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
Juri Shimon wrote:
Hi,
Hello miguel,
Tuesday, October 19, 2004, 10:52:03 PM, you wrote:
ms Hi,
ms Thank you for reporting this bug, I already opened the below
ms bug report:
ms http://bugs.mysql.com/bug.php?id=6165
How to repeat:
create table t0 (id int not null auto_increment primary key,
foo
If you are using a replica, you can grab the information from SHOW
SLAVE STATUS or SHOW MASTER STATUS. I'm not too sure if there is a
call for non-replicated database servers for this.
BTW, if you aren't locking everything you're dumping, you'll probably
never get a consistent state if you want
If you need the table definitions as part of your dump, you could truncate
those tables right before you run mysqldump then restore the data right
after you finish.
If you can get rid of them during the dump, then: drop your temp tables,
do a full database backup, re-create your tables.
If
Thanks Brent, your solution is the one that worked for me. In 4.0.20
there was no 'Super_priv' column however. ?
On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley [EMAIL PROTECTED] wrote:
There probably is a root user, but it's not called root. You can name
the root user whatever you want.
There probably is a root user, but it's not called root. You can name
the root user whatever you want. You probably just don't have a user
named root, which is why you can change the password for user root.
You want to start MySQL with the skip grant tables options, just like
in the
I would use the --tables option of mysqldump. It accepts more than one
table name, so all you need to do is make a list of the tables you want
dumped. If you are combining --tables with other options (like
-B/--databases or -u or -p) make sure the --tables option is the LAST
parameter in the
Create a script that would evoke the mysqldump let crond schedule the
task.
If you're using windows, a batch file will do create a schedule task for
your batch file.
- Original Message -
From: Sparks [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 8:22 PM
Subject:
At 16:13 -0400 8/31/04, Emi Lu wrote:
Hello all,
In mysql, do we have a way to mysqldump all tables except two in a
database. I know we have the way only dump schema, only data, a
specific table, both data structure and data. But could someone help
me about dumping all tables in a structure
- Original Message -
From: Emi Lu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 4:13 PM
Subject: mysqldump all tables except 2 in a database
Hello all,
In mysql, do we have a way to mysqldump all tables except two in a
database. I know we have the way only
I have a script on my site that I call smalltables. When run, it
echoes out the names of all of the tables _except_ for the large
ones that I don't back up. I then use this in the mysqldump
command line:
/usr/local/mysql/bin/mysqldump -q --user=UUU --host=localhost
--password=PPP DB_NAME
Jim McAtee [EMAIL PROTECTED] wrote:
Can I easily restore individual databases and/or individual tables from a
backup made with mysqldump?
Yes if you will individually dump the tables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Ginger Cheng [EMAIL PROTECTED] wrote:
If a table has a column defined as 'float not null' and the corresponding
txt file used to load it have sth like 'nan' for the column, although
giving warnings, the record will be loaded and the column looks like 'nan'
by using mysqlimport. But
At 20:58 -0600 7/21/04, Jim McAtee wrote:
(Apologies in advance for the crossposting, but I asked the same questions
on the MySQL Windows list and didn't get any replies)
I need a simple backup mechanism for MySQL (3.2x) that will backup all
databases on a server. Something that can be run from a
Ginger Cheng wrote:
Hello, MySQL gurus,
Since I have been moving data around using mysqldump recently, I
have found sth annoying:
If a table has a column defined as 'float not null' and the
corresponding txt file used to load it have sth like 'nan' for the
column, although giving
24 = Too many open files.
I think you can resolve this issue by increasing the number of file
descriptors available to mysqld by setting an appropriately higher
'open-files-limit' in your configuration.
--bmansell
Brian E. Mansell
MySQL Professional
On Thu, 22 Jul 2004 13:20:24 +0200, Wolfgang
Assume DB1
tab1
tab2
...
Do
$mysqldump -u user DB1 DB1.sql
Remember if you have a password set for this user (which ideally should
be) use the -p option.
$mysql -u user -e create database DB2
This line will create the new database
$mysql -u root DB2 DB1.sql
This will put all your tables and
On Thu, 3 Jun 2004 11:54 , McKeever Chris [EMAIL PROTECTED] sent:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling
that tables dont exist whenever I put a where clause
in..
it runs fine when I leave the where clause off - any help here?
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling
that tables dont exist whenever I put a where clause in..
it runs fine when I leave the where clause off - any help here?
mysqldump -u root -p hotswap EmailDatabase_k
On Thu, 03 Jun 2004 12:07 , gerald_clark [EMAIL PROTECTED] sent:
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it keeps
yelling that tables dont exist whenever I put a where clause
in..
it runs fine when I leave the where clause
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it
keeps yelling that tables dont exist whenever I put a where clause in..
it runs fine when I leave the where clause off - any help here?
mysqldump -u root -p hotswap EmailDatabase_k
On Thu, 03 Jun 2004 13:57 , Michael Stassen [EMAIL PROTECTED] sent:
McKeever Chris wrote:
MYSQL 4.0.13
I must be doing something wrong - I am trying to do a mysql dump and it
keeps yelling that tables dont exist whenever I put a where clause in..
it runs fine when I leave the where
Here's a simple python script that I use to do mysql backups. I wrote it
myself. It works great. Cron it to run however you like:
def db_backup():
import os, time
# Change db_list contents to reflect the names of your databases.
db_list =
On Tue, Jun 01, 2004 at 09:28:37AM -0400, adam wrote:
mysqldump --user=root --password=root-password --opt bugs
$BACKUPDIR$BACKUPSQLFILE
My problem is that it does not seem to work when the crond calls the script.
The result of the dump is a zero size sql file.
Don't you get the output
Josef Karthauser [EMAIL PROTECTED] wrote:
In the old days of mysql (version 3.x) the mysqldump command would
produce one text line per database row, but since then it appears to
have been replaced with an extended insert format which is more
efficient for getting data back into the database.
On Fri, May 28, 2004 at 03:05:53PM +0300, Victoria Reznichenko wrote:
Josef Karthauser [EMAIL PROTECTED] wrote:
In the old days of mysql (version 3.x) the mysqldump command would
produce one text line per database row, but since then it appears to
have been replaced with an extended insert
Josef Karthauser [EMAIL PROTECTED] wrote:
On Fri, May 28, 2004 at 03:05:53PM +0300, Victoria Reznichenko wrote:
Josef Karthauser [EMAIL PROTECTED] wrote:
In the old days of mysql (version 3.x) the mysqldump command would
produce one text line per database row, but since then it appears to
PROTECTED]
Subject: RE: mysqldump problem
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
Consider the OS and filesystem as well (wheatever uyou _are_ using; you
didn't tell us).
Quotas? Limits by FS? getrlimit()?
Would this by any chance be dumping to a disk formatted with the FAT32
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi,
I've been using mysqldump to backup my entire database. Every day, I restore the
whole thing to my test/develop database by piping the large sql generated by
mysqldump. All is well until the file size of the sql file reached
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
-Original Message-
From: Brian Reichert [mailto:[EMAIL PROTECTED]
Sent: 24 May 2004 15:42
To: Gilbert Wu
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump problem
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi
TABLES; in the middle of the insertion block. Hence, the syntax error during
restoration.
Is this a mysqldump bug?
Regards,
Gilbert
-Original Message-
From: Gilbert Wu
Sent: 24 May 2004 17:10
To: Brian Reichert
Cc: [EMAIL PROTECTED]
Subject: RE: mysqldump problem
Sorry, I am running
Gabe,
There are actually some problems caused by how auto increments are tracked
in the database. We do our backups by using mysqldump at night and
preserving all of the log files that were created during the day. The
problem occurs during recovery where auto increment values can be
incremented
Joe Adams wrote:
I have a database setup for replication. I used mysqldump --opt db db.dmp
to do the initial backup of the primary database (after doing a flush tables
with read lock in a seperate session).
I checked the dump file, and all drop table create table statements are in
the file.
The oracle and MySQL create syntax is not completely compabitable. You will
have to identify and correct the errors.
For example text data type in MySQL may need to be either VARCHAR(N) or
CLOB.
...
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/28/04 11:37 PM
At 11:57 -0500 4/21/04, Carl Karsten wrote:
I am sure that i used mysqldump to create a script that had both CREATE TABLE
and GRANT commands, but now I can't figure out how.
mysqldump doesn't generate GRANT statements.
Perhaps you are thinking of some other program.
--
Paul DuBois, MySQL
From your description, I assume you already have data in an existing version
4 database that has existing table structures that are different from your
3.23 dump.
One method of preserving your existing 4.x data would be to create a new
database in the 4.x version for importing your 3.23 data.
Patrick,
From your description, I assume you already have data in an existing
version
4 database that has existing table structures that are different from your
3.23 dump.
I didn´t have datas, but I had already run the mysql upgrade script.
Because the original version of the MySQL in Linux
Hello Joe,
mysqldump is a seperate programto be execute at the system prompt.
Therefore it is not to be run under the mysql prompt.
Bernard
On Friday 26 March 2004 06:09, joe collins wrote:
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the
joe collins [EMAIL PROTECTED] wrote:
I have read the documentation on the MySQLDump, but have been unable to
launch a mysql dump.
Is the dump performed while logged on to the database that you want to
dump, or do you log onto the machine where the database is and specify
which database you
First, mysqldump is a command in and of itself so it does NOT execute from
within the mysql command line tool. Next, expand your command entry a bit
to include your userid and password, for example:
mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql
-Original
-ppassword --no-data mtweblog mtweblog.ddl
mysql -uuser -ppassword mtweblog.ddl
mysql -uuser -ppassword bkupmtweblog.sql
-Original Message-
From: tait sanders [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 5:13 PM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: Re: mysqldump error
thanks - i ran the command below and it worked. and now I'm trying to
import using:
'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different
machine and am getting Error 1 at line 11: Can't create/write to
file'./mtweblog/mt_author.frm' Errorcode 13.
any suggestions here?
tait
On
At 10:12 +1100 3/22/04, tait sanders wrote:
thanks - i ran the command below and it worked. and now I'm trying
to import using:
'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different
machine and am getting Error 1 at line 11: Can't create/write to
file'./mtweblog/mt_author.frm'
[EMAIL PROTECTED] wrote:
I would like to do the following:
mysqldump -w users.user_id=enews.user_id sotx users
c:/enews_users.sql
Ideally this would dump all records in table users
where the user_id field value is also present in the
enews table. Is this possible?
You can't do it only
.
Thanks, Rhino.
-dan
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 5:58 PM
To: [EMAIL PROTECTED]
Subject: Re: mysqldump JOIN?
According to the mysqldump article in the manual -
http://www.mysql.com/doc/en/mysqldump.html -
you can select specific rows
Odd. When I dump my utf8 database it works fine. I use
mysqldump -u user --password=password -a -A --add-drop-table -c
public_html/backup.sql
This backs up my entire database. Here is the limk to it in the manual
http://www.mysql.com/doc/en/mysqldump.html
I hope it helps.
Respectfully,
Ligaya
At 2:50 +0200 2/26/04, Lorderon wrote:
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT * FROM tbl WHERE id100 AND id200;
mysqldump --help shows that it takes a --where / -w option.
So:
mysqldump -w id100
Something like that:
SELECT - INTO OUTFILE 'filename' FROM Table etc etc ;
Marcelo Araujo
On Wednesday 25 February 2004 21:50, Lorderon wrote:
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT *
in which table i set to use Charset (UTF-8).
But When i use mysqlmysqldump -u myname -p mypwd telbookbook.txt, all
string of table friend's c_name will become ?.
Have you tried:
mysqldump --default-character-set=utf8 -u myname -p mypwd telbookbook.txt
If that doesn't work, which version
Hi,
Yeah, by default mysqldump buffers the result of the SELECT * FROM
table query in memory before writing the SQL statements (using
mysql_store_result()). If you use the --opt option (or at least -q
or --quick), it dumps the data as it gets it (using mysql_use_result()).
Hope that helps.
Pete,
what does
SHOW VARIABLES LIKE '%timeout%';
say?
Does the MNRD mysqld server crash? Anything in the .err log?
What do you have as max_packet_size in my.cnf? Could row: 13154861 be bigger
than that?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions,
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Friday, December 19, 2003 10:28 AM
To: [EMAIL PROTECTED]
Subject: mysqldump table order with foreign keys
Hey all,
I'm
At 11:16 -0600 12/19/03, Victor Pendleton wrote:
You will need to place the following at the head of your dump file.
SET FOREIGN_KEY_CHECKS=0
Also, in MySQL 4.1, mysqldump does this automatically. It puts out
the following at the beginning of the dump file:
/*!40014 SET
What mysqldump does?
I dont know it because i am new in the world of databases
Andre Winarko [EMAIL PROTECTED] wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
Zenzo [EMAIL PROTECTED] wrote:
What mysqldump does?
I dont know it because i am new in the world of databases
mysqldump makes dump of the database or databases:
http://www.mysql.com/doc/en/mysqldump.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Andre Winarko wrote:
I have problem with mysqldump.
This query results an error.
mysqldump danamon [trx_temp2] trx_temp2.sql
The error message is :
mysqldump : Can't get CREATE TABLE for table
'[trx_temp2]' Table 'danamon.[trx_temp2]' doesn't
exist
I'm sure the trx_temp2 table in danamon
Thanks...
I will try that :)
patrick
From: Victor Pendleton [EMAIL PROTECTED]
To: 'patrick kuah' [EMAIL PROTECTED], Victor Pendleton
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: mysqldump query
Date: Mon, 17 Nov 2003 09:38:56 -0600
Are you running on a Linux platform?
File = .my.cnf
you could put the password in your .my.cnf file and change permissions so
that only the MySQL user can read the file.
-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:15 AM
To: [EMAIL PROTECTED]
Subject: mysqldump query
Hi guys,
I have
Hi Victor,
Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)
From: Victor Pendleton [EMAIL PROTECTED]
To: 'patrick kuah' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: mysqldump query
Date: Mon, 17 Nov 2003 07:06:18 -0600
you could put the password in your
, November 17, 2003 9:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysqldump query
Hi Victor,
Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)
From: Victor Pendleton [EMAIL PROTECTED]
To: 'patrick kuah' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE
On Tue, Nov 04, 2003 at 05:32:47PM +0100, Al Bogner wrote:
Is it possible to sort the records, which are created with
mysqldump? I didn't find an optioin in man mysqldump. If you cannot
do it with mysqldump, what would be the best workaroud for it? into
outfile?
Have you tried sneaking an
At 11:10 -0500 10/15/03, Terry Cheryl Haimann wrote:
I have a mysql 3.23 running under win98. I also have a database
with a largeblob, which has a jpeg image in it.
Now I am trying to upload this to a free server using the following
command to export the table:
bin/mysqldump -u user
For the free web server, the transfer was web based using MyPHPAdmin.
To test it on my RedHat 8.0 box(my home network server,) I copied the file to my Samba
directory with Windows Explorer
Then I switched over and signed on and did the import.
On Wed, 15 Oct 2003 11:37:32 -0500, Paul DuBois
Are you attempting any sort of editing of the exported file?
We routinely dump our production database, which includes several tables
that hold TIF images, with no problems at all. In fact, we'll also transfer
data between servers with a command like:
Mysqldump --add-drop-table databasename
Yes, that seems to be part of the problem. I still seem to be loosing some images
though.
And how can I upload to PHPMyAdmin without altering the comments that mysqldump
creates.
Terry
On Wed, 15 Oct 2003 12:05:19 -0500, Christensen, Dave wrote:
Are you attempting any sort of editing of
On Monday, October 6, 2003, at 05:11 PM, Paul DuBois wrote:
I don't understand. Here you say that mysqldump is in the path, but
above
you say that you don't know if mysqldump is in the path for cron jobs.
I suggest you change the crontab entry to invoke mysqldump by its full
pathname and then
At 16:33 -0400 10/6/03, Patrick Larkin wrote:
Hello -
I have the following command to back up a MySQL database on a remote
machine. Works beautifully from the command line when run manually
as root:
mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote:
Does the PATH setting for jobs run by cron include the directory where
mysqldump is
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote:
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote:
Does the PATH setting for
At 17:09 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote:
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM,
So then Paul DuBois says...
One way to set the path would be to place your mysqldump command in
a helper script:
#! /bin/sh
export PATH=your-path-setting-here
mysqldump
Then invoke the helper script from the crontab, rather than invoking
mysqldump directly.
You can set the PATH in
Try putting the name inside of backticks;
From the Manual:
6.1.2 Database, Table, Index, Column, and Alias Names
---
Note that if the identifier is a restricted word or contains special characters you
must always
quote it with a
301 - 400 of 576 matches
Mail list logo