Not a bad Idea. I guess I will have to hit the php mailing list to find
out about this because I tried the following in PHP and it still did the
same thing.
", $test);
echo "$test";
?>
I can't seem to get the "passthru" into a variable. It always displays the
results instead.
Thank You
Stev
On Fri, 2002-04-12 at 10:56, Steve Buehler wrote:
> I am using PHP to run the following command:
> passthru("mysqldump -q -u$userName -p$password -h$hostName $databaseName");
>
> The problem is that it puts EVERYTHING on one line and, of course, and
> wraps it. I want to be able to dump the dum
kaps,
Sunday, March 31, 2002, 9:54:00 AM, you wrote:
k> i m fairly new to mySQL. I have to work on already set up live database
k> which can be managedwith phpAdmin system.
k> Now i was wondering how can i take a backup (dump) of the database with that
k> system?
Use mysqldump utility: http:
hi guys!!
i m fairly new to mySQL. I have to work on already set up live database
which can be managedwith phpAdmin system.
Now i was wondering how can i take a backup (dump) of the database with that
system?
I have figured out how can i do it if i have to work on mySQL Server
instead.
Any he
your answer
>Okan
>
>
>2 rows in set (0.00 sec)
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Okan CIMEN" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, March 30, 2002 4:42 PM
>Subject: Re: mys
uBois" <[EMAIL PROTECTED]>
To: "Okan CIMEN" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 4:42 PM
Subject: Re: mysqldump problem
> At 16:21 +0200 3/30/02, Okan CIMEN wrote:
> >Hello,
> >
> >When I try to get the remote
At 16:21 +0200 3/30/02, Okan CIMEN wrote:
>Hello,
>
>When I try to get the remote dump of a database, I get the table structure
>without any failure but it is not able to get the table data. Has anyone of
>you came over to this problem before?
>Here is what I have tried:
-T requires that you have
abase.mysql
Date: Monday, March 25, 2002 10:44 AM
Subject: Re: mysqldump : help needed very urgent
>Hi,
>
>as far as we are waiting for 3.23.50 this sounds as a stable version to
>do a backup. :-)
>But I wonder weather there is also a binary backup for this case? Lets
>say copy
Hi,
as far as we are waiting for 3.23.50 this sounds as a stable version to
do a backup. :-)
But I wonder weather there is also a binary backup for this case? Lets
say copy all tables and store in a zip (for ISAM tables ok but
InnoDB???), or make a mysqlhotcopy.
Adib.
Chetan Lavti wrote:
> t
thank u very much...
but I am planning for one approach is it right ..
as by mysqldump we can take back up of Table structure and Insert values
separately..
As my database will remain constant through out for the application I
can insert the foreign key lines in the dumped file once and as the
in
hi,
I am also using the Innodb table type for my database. when I am using
the mysqldump for dumping the tables it really doesn't shows the
foreign key in the table structure.
but if after deleting my previous database I again create my database
using the same dumped file and executes the
mysql
From: Boaz Yahav <[EMAIL PROTECTED]>
> 1. I was wondering if there is any way to backup MySQL information other
> than MySQLDump?
In some cercomstances, you can simply copy the database file, but this can possese
real problems. Are you running your backups durring peak hours, or in the middle o
I've encountered a similar problem which seems to stem from a "larger"
problem of MySQL thinking it's out of memory. It manifests itself in several
ways:
- when INSERT'ing a row into a table which stores binary data in a LONGBLOB
column, I get one of several "out of memory" errors ("Out of memory
Dennis Wu wrote:
> I have a table with a column defined as BLOB. However, when I dump
> this table using ./mysqldump, the dump file cannot be imported. Is
> that because a binary field cannot be dumped into a text file? Any
> solution if I really need to do the backup by dumping the table?
W
Hi!
> "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes:
Benjamin> Hi.
Benjamin> On Wed, Dec 19, 2001 at 05:03:25PM -0700, [EMAIL PROTECTED] wrote:
>> >Description:
>> This problem pertains to the Sun Solaris distributions, I have
>> not tried others. Description follows:
>> mysql
Hi.
On Wed, Dec 19, 2001 at 05:03:25PM -0700, [EMAIL PROTECTED] wrote:
> >Description:
> This problem pertains to the Sun Solaris distributions, I have
> not tried others. Description follows:
> mysqldump --tab runs up against user resource limits on the
> number of open f
Rory,
Take a look at the shell scripts for mysqlbackup here
http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain
things quite nicely.
Cheers,
m!
ROry O'Connor wrote:
>this is an absolute newbie question - but when i try to run mysqldump with a cron
>(like with a shell scr
Am 20 Dec 2001 03:35:37 -0600 schrieb ROry O'Connor:
> this is an absolute newbie question - but when i try to run mysqldump with a cron
>(like with a shell script) i can't because mysqldump utility stops to ask for a
>password. how can I either embed the password or set up mysqldump to not ask
You could use one of:
1. .my.cnf with a password set for the client
2. use -p on the command line
Depends on how secure you want it - use the appropriate grant for the user.
M
-Original Message-
From: ROry O'Connor [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2001 09:36
To: [EMAIL PRO
: [EMAIL PROTECTED]
Sent: 12/1/2001 6:35 AM
Subject: RE: mysqldump: problem/question
Weaver, Walt writes:
> I knew it. Nobody bothered to read my post.
>
> The original problem involved running a lightweight version of
mysqldump in
> a simulated nanokernel environment with reduced power re
Weaver, Walt writes:
> I knew it. Nobody bothered to read my post.
>
> The original problem involved running a lightweight version of mysqldump in
> a simulated nanokernel environment with reduced power resources. The
> ultimate result, we hope, is to use it to record Quidditch matches being
> pl
,
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
From: sherzodR
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Sent: 11/30/2001 3:14 AM
Subject: re: mysqldump: problem/question
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains for the last two days
WW: trying to solve my problem of mysqldump running out of memory while dumping
WW: a large table.
WW:
WW: I figured it out, so you can all go on wi
Okay, I know you guys have been wracking your brains for the last two days
trying to solve my problem of mysqldump running out of memory while dumping
a large table.
I figured it out, so you can all go on with your lives.
My copy of Paul DuBois' MySQL book came today and immediately solved my
pr
Hi.
On Mon, Nov 26, 2001 at 05:39:57PM +0300, [EMAIL PROTECTED] wrote:
[...]
> diff database_dump/Mtable.txt `mysqldump
> --databases MYdatabase --tables MYtable`
> ...
> and make a conclusions depending of diff output.
>
> But according to well known SQL standarts the order of stored records i
Hello George!
On Sat, 24 Nov 2001, georgem wrote:
> Hi all,
>
> mysql v 3.23.32. I've started using mysqldump to backup my databases but
> have run into a strange problem with decimal numbers. As I understand it,
> mysql treats decimals like strings so to insert a value into a decimal field
> y
Chris Aitken writes:
> Hi all,
>
>
> Just a real quick question about using mysqldump. Should I shutdown mysql
> before running mysqldump, or can I successfully do a mysqldump of my whole
> database while mysql is still running/processing records.
>
>
> I have a very big database, and want t
>
> Hi.
>
> I'm trying to run a mysqldump. I enter mysqldump
> -databases in order to backup all the databases. For
> some reason all I'm getting back is a help on the
> mysqldump. What am I doing wrong?
>
> thanks
>
> =
>
It returns help whenever it doesn't understand what you're asking it
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote:
>Hi.
>
>I'm trying to run a mysqldump. I enter mysqldump
>-databases in order to backup all the databases. For
>some reason all I'm getting back is a help on the
>mysqldump. What am I doing wrong?
If you're really entering the option as -databases,
daniel james ([EMAIL PROTECTED]) writes:
> I need to generate a tab-delimited text dump of table
> data ONLY and have it output to a text file. I don't
> want any table info, delimiters, etc. I need this to
> copy/paste into a excel spreadsheet. What's the
> syntax?
>
> I'm stuck here:
>
> %
daniel james wrote:
>
> I need to generate a tab-delimited text dump of table
> data ONLY and have it output to a text file. I don't
> want any table info, delimiters, etc. I need this to
> copy/paste into a excel spreadsheet. What's the
> syntax?
>
> I'm stuck here:
Hi:
What do you think ab
Date |Wed, 22 Aug 2001 13:08:20 +0300 (EEST)
>From |"scott.alexander" <[EMAIL PROTECTED]>
Hello!
S> When I am on machine A and my database is on machine B can I force
S> mysqldump to dump the data to files on machine A.
S> When I try from machine A and use mysqldump it dumps to a directory in
S
Date |Wed, 8 Aug 2001 23:02:26 -0400
>From |"Wendell Dingus" <[EMAIL PROTECTED]>
Hello!
WD> Right after that last C is my # command prompt with no line-ending character
WD> in the file. It gets part way through the describe of the table layout and
WD> stops. Using phpMyAdmin I can view everythin
On 28-Jul-2001 azharmg wrote:
> hi..good day,
>
> how to filter the fields from table that we wish to dump it..
> ie.table : abc fields:name,address,phone..
>
> so we only want dump for field name and address only,...
> how to do that..
>
Start with this:
localhost.dread$ cat csvdmp
#!/bin/
Some RDBMS allow you set a 'seed' value for auto-incrementing columns. I
haven't looked at this in awhile, but I know of a couple of work-arounds:
- Set the first record in your INSERT to an explicit value (4711, etc.),
then put NULLs in subsequent rows.
- Insert a bogus record with a number one
At 11:03 PM +0200 7/17/01, Alexander Skwar wrote:
>So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
>> in my plain language there it is, but the pro's may give a more detailed
>> approach.
>
>Yeah, that's sorta how I understand it as well. Also auto_increments
>BREAK when you
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
> in my plain language there it is, but the pro's may give a more detailed
> approach.
Yeah, that's sorta how I understand it as well. Also auto_increments
BREAK when you manually insert a row and set the column with the
auto_inc
Hi
I am no pro with Mysql, but had similar results when first starting out. My
understanding is that the Auto Increment value is held in a file other than
the actual data file, so when it uses the auto-increment it is not reading
the last value from the actual DB and then adding one, but rather l
Thank you!
It seems to be hard to be understood on this mailling list ;-)
Le Tue, Jun 19, 2001 at 10:17:35AM -0500, Pete Harlan a écrit:
> It would seem that there is a bug, and it's that "create table"
> accepts an 'illegal' definition. It should either convert the integer
> to a literal (makin
It would seem that there is a bug, and it's that "create table"
accepts an 'illegal' definition. It should either convert the integer
to a literal (making the definition legal and dumpable), or it should
barf on it.
IMO, of course.
--Pete
[Charset iso-8859-1 unsupported, filtering to ASCII...
But my problem is perhaps simply in the concept:
When MySQL accept a create table in entry (as bad as it is like this one from a guy in
my team), mysqldump should regenerate from this table a create table statement
accepted by MySQL too.
no? it's not logic?
;-)
Regards,
Le Mon, Jun 18, 2001
Sinisa,
A good way to prove that mysqldump is doing what it should, might be to do a
describe TESTBADDUMP;
I think this will prove that mysqldump is just dumping what is in the table
def, which is all you can expect.
Have a great day...
John
On Monday 18 June 2001 09:46, Sinisa Milivojevic w
Guillaume Fougnies writes:
>
> ok so it's a failure from mysqldump.
>
> I know this declaration is not really correct but mysqldump must regenerate a
>correct sql statement (good when pipe in mysql client i mean at least ;) ).
> It's not the case.
>
> Regards,
> --
> Guillaume FOUGNIES
> Resea
nator is trying to show. That mysqldump is
generating an invalid statement.
thanks,
-- Andrew
- Original Message -
From: "Thomas Karcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 9:08 AM
Subject: Re: mysqldump bug during regenerate
Le Mon, Jun 18, 2001 at 04:04:52PM +0300, Sinisa Milivojevic a écrit:
> [EMAIL PROTECTED] writes:
> > mysqldump regenerates a bad sql statement from a bad initial create table.
> >
> > When you create this table for example (ok it's not a really nice definition):
> >
> > CREATE TABLE TESTBADDUMP
Try quoting (' ') the 0 in your create:
CREATE TABLE TESTBADDUMP (
e_test enum('0','1') NOT NULL default '0' );
-^
You should then get the result you want.
Have a great day...
John
On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote:
> mysqldump r
Hi,
> mysqldump regenerates a bad sql statement from a bad initial create table.
>
> When you create this table for example (ok it's not a really nice definition):
>
> CREATE TABLE TESTBADDUMP (
> e_test enum('0','1') NOT NULL default 0
> );
>
> desc TESTBADDUMP;
> +---
[EMAIL PROTECTED] writes:
> mysqldump regenerates a bad sql statement from a bad initial create table.
>
> When you create this table for example (ok it's not a really nice definition):
>
> CREATE TABLE TESTBADDUMP (
> e_test enum('0','1') NOT NULL default 0
> );
>
> desc
- Original Message -
> In the last episode (Jun 15), SDiZ Cheng said:
> > When i use mysqldump,
> > seems that MySQL will open all the tables in the database.
> > But, what i have is: a database will over 10,000 tables ..
> > I get a "Too much opened file" error on this..
> > I think incre
Hello
I created a perl script that might help. Because I like to have a full backup
of my databases and table backups (I know I can split the full backup, but
I'm too lazy ;), I created a perl script that queries MySQL for the table
names in the database and then creates a shell script with in
In the last episode (Jun 15), SDiZ Cheng said:
> When i use mysqldump,
> seems that MySQL will open all the tables in the database.
> But, what i have is: a database will over 10,000 tables ..
> I get a "Too much opened file" error on this..
> I think increasing open_file_limit is not possible,
>
Yes.. I know.. But that's not my design.
That will be change in a few month..
My job now is: dump all of them out.
- Original Message -
> Wow! What kind of database would have 10,000 tables? Wouldn't you think
> the database design had a serious flaw in the first place?
>
> Seung-woo Na
Wow! What kind of database would have 10,000 tables? Wouldn't you think
the database design had a serious flaw in the first place?
Seung-woo Nam
SDiZ Cheng wrote:
>When i use mysqldump,
>seems that MySQL will open all the tables in the database.
>But, what i have is: a database will over 10,00
o: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, June 10, 2001 5:27 PM
Subject: Re: mysqldump question
> [EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
>
> > Is there a way that I can make mysqldump output a row in a single line ?
> > The line is fairly long, an
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> Is there a way that I can make mysqldump output a row in a single line ?
> The line is fairly long, and wraps to something like 20 lines or so,
> due to one column that is a clob. Total there are 67K records.
I thought the default was to not wrap
You need to use the following when you build mysql to use all options.
CC=gcc CXX=gcc ./configure --prefix=/usr/local/mysql --enable-thread-safe-client
--with-berkeley-db=./bdb --with-innodb
Not that CXX is gcc and not the c++ compiler from SCO.
Good Luck,
--
Boyd Gerber <[EMAIL PROTECTED]>
>Hi,
>
>I'm using mysqldump to backup my databases. Does anyone know if mysqldump
>locks all the tables in the database prior to performing the dump?
>
>I ask this because if an update is in progress which inserts/modifies
>records in several tables, performing a mysqldump could backup the databa
hi, i did follow what as follow ..
c:\mysql\bin\mysqldump samp_db > c:\archieves.mysql
but, it shows error as follow :-
mysqldump: Got error: 1045: access denied for user: 'ODBC@localhost'
when trying to connect.
why ? How ?
Original Message-
>Hello
>
>It's s
I prefer dumping things one database at a time so I can more easily
recover them. See script below, run from the mysqlback directory which
is at the same level as the directory containing the directories of all
of the files.
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategie
>From 'man mysqldump'
mysqldump [OPTIONS] --all-databases [OPTIONS]
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Marco Kammerer" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Tu
On Wed, May 16, 2001 at 03:12:42PM -0700, Brian Warn wrote:
> I'm looking at different ways to backup a database from a solaris
> 2.8 box to a solaris 2.7 one. In addition to the standard system
> backups that our sysadmins do during the week, I want to do a full
> backup of the database to a bo
You probably need to boost the memory limits up in your shell (ie with bash
see man ulimit)
Mike
Jeremiah Griffin wrote:
>
> Howdy,
>
> I am trying to run mysqldump and I am getting a memory error.
>
> =
> mysqldump: Out of memory (Needed 65576 bytes)
> mysqldump: Got error: 2
FYI, I tested MySQL 3.23.36 with the same setup as below.
I got identical results.
-Original Message-
From: Ide, Jim
Sent: Saturday, March 31, 2001 4:59 PM
To: '[EMAIL PROTECTED]'
Subject: mysqldump hangs
OpenBSD 2.8
swap partition is 256mb
/tmp partition is 1gb
Pentium III 667mhz, 25
I should start reading this list more..
I've had a similar problem, and good luck finding many people who'll help
you with OBSD problems on this list (or any problems for that matter).
Anywho, it's ports specific I think. I installed MySQL from source
compiling with -O6 and the proper arch (like
On 21-Mar-01 Randy Johnson wrote:
> Hello,
>
>
> is there anyway to execute a mysqldump command via the web and have the dump
> stored on a file on the server.
yes.
$cmd="/usr/local/bin/mysqldump -u user -ppasswd db
$cmd .=" > /path/to/dump/db.dmp";
system($cmd);
> do any of the webinterface
"Kristian Köhntopp" <[EMAIL PROTECTED]>@mail.netuse.de on 03/16/2001 02:02:28 PM
?Sent by: [EMAIL PROTECTED]
?To: [EMAIL PROTECTED]
?cc: [EMAIL PROTECTED]
?Subject: Re: mysqldump problem?
?
?
?[EMAIL PROTECTED] wrote:
?> This seems to be a competability feater, so y
[EMAIL PROTECTED] wrote:
> This seems to be a competability feater, so you can load it into db2,
> oracle etc.
But not into MySQL - great idea. :-)
Kristian
--
Kristian Köhntopp, NetUSE AG Siemenswall, D-24107 Kiel
Tel: +49 431 386 436 00, Fax: +49 431 386 435 99
-
It is a known problem, I saw a bug report go through about it a day or so ago.
One workaround I found is to rename the key. I think the problem may have
something to do with the name of the key also being column name or a
special token.
In my case, I had:
int User,
key User(User)
and I chan
This seems to be a competability feater, so you can load it into db2,
oracle etc.
"Kristian Köhntopp" <[EMAIL PROTECTED]>@mail.netuse.de on 03/16/2001 01:06:30 PM
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: mysqldump problem?
Short version: mysqldump seems to p
Kristian Köhntopp wrote:
> Short version: mysqldump seems to produce a "KEY mid(mid)"
> statement, which mysql does not understand. Using
> KEY (mid) instead of KEY mid(mid) works, though.
>
> Is this a known problem? Is this an oversight by me?
Ultrashort resolution: kris is stupid and mid is a
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
iginal Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'Joel Caturia'" <[EMAIL PROTECTED]>; "Gerald L. Clark"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 2:19 PM
Subject: RE: my
Hi,
But is your mysql server run by root, or, as advised, by 'mysql'?
Quentin
-Original Message-
From: Joel Caturia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 10:56 a.m.
To: Gerald L. Clark
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump Error
ah but I do.. A
Hi,
Error 13 is permissions. Your server has to have permission to write to the
directory, and over-write any existing file of the same name.
Regards
Quentin
-Original Message-
From: Joel Caturia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 10:07 a.m.
To: [EMAIL PROTECTED]
> "JC" == Joel Caturia <[EMAIL PROTECTED]> writes:
JC> I've searched around a bit, and haven't been able to find what an
JC> errcode 13 is, so I'm out of ideas.
mysql comes with a program called perror. Run "perror 13" and see
what it has to say.
Also, what are your mysql permissions (from
l Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Joel Caturia" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:43 PM
Subject: Re: mysqldump Error
> Joel Caturia wrote:
> >
> > I'm trying to use mysq
Joel Caturia wrote:
>
> I'm trying to use mysqldump to dump a database (obviously).
>
> Here's the commandline I'm using:
> [root@fugu work]# mysqldump --tab=. wonderdesk
>
> mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode:
>13)
>
> The interesting thing, i
on 3/7/01 6:39 PM, Cindy at [EMAIL PROTECTED] wrote:
> How would I copy ONE table from a database over to another?
>
> I used this last time:
>
> mysqldump -h mysql.io.com -u DB1 -p --opt DB1 > ! backup-file.sql
> mysql -h mysql.io.com -u DB2 -p DB2 < backup-file.sql
>
> But it copies the who
Hi,
Just add your table name to the mysqldump command
Quentin
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 2:40 p.m.
To: [EMAIL PROTECTED]
Subject: mysqldump question
How would I copy ONE table from a database over to another?
I used this la
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
> Matt Loschert writes:
> > On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
> >
> > > [EMAIL PROTECTED] writes:
> > > > >Description:
> > > >
> > > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the
>flags:
> > > >
Matt Loschert writes:
> On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
>
> > [EMAIL PROTECTED] writes:
> > > >Description:
> > >
> > > As of mysql 3.23.33, a dumpfile generated with mysqldump (using the
>flags:
> > > --opt --all-databases) creates a file which will no
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote:
> [EMAIL PROTECTED] writes:
> > >Description:
> >
> >As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags:
> > --opt --all-databases) creates a file which will not be uploaded correctly
> > using the mysq
[EMAIL PROTECTED] writes:
> >Description:
>
> As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags:
> --opt --all-databases) creates a file which will not be uploaded correctly
> using the mysql client (as in: 'mysql -u root -pXX -q -s <
>dumpf
jaco wrote:
>
> I'm having problems with mysqldump too.
>
> I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root,
>typing ./mysqldump --all-databases > backup.sql
>
> as is explained on http://www.mysql.com/doc/m/y/mysqldump.html
>
> The response is : ./mysqldump:
On Mon, Feb 19, 2001 at 12:22:04PM -0800, John Jensen wrote:
> Okay, so I got it using the mysql root password as an option, but I
> find not evidence of a backup or sql file being created, unless I add
> a pipe and redirection instructions to the command. The mysqldump
> command is either putt
On Mon, Feb 19, 2001 at 09:26:34PM +0100, jaco wrote:
> I'm having problems with mysqldump too.
>
> I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root,
>typing ./mysqldump --all-databases > backup.sql
>
> as is explained on http://www.mysql.com/doc/m/y/mysqldump.html
Thank you Fred, that helps
On 19 Feb 2001, at 21:23, Fred van Engen wrote:
> On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote:
> > I have an existing mysql database I am trying to back up before
> > upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin
> > commands tell me I
By "even as root", do you mean that you did something like this:
$ mysqldump -u root -p db_name > db_name.sql
? The "root" user *in* MySQL should have privileges to run
mysqldump. Describe the situation in a little more detail if
you're still having problems - like:
* what is the exact mysq
On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote:
> I have an existing mysql database I am trying to back up before
> upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin
> commands tell me I am accessing as the wrong user when I execute from
> the bash prompt, even as root
Okay, so I got it using the mysql root password as an option, but I
find not evidence of a backup or sql file being created, unless I add
a pipe and redirection instructions to the command. The mysqldump
command is either putting the dump in a location I don't know about
(and can't seem to fin
Marcos Krzisch writes:
> Hi!
>
>I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump.
> I've tried different options, now I'm currently running:
>
> mysqldump -F -l -q -O max_allowed_packet=16777216 db
>
> but sometimes mysql core dumps.
>
> Thanks for any
hi
mysqldump -u (username) -h (hostname) -p databasename tablename>filename
password
then upload the same whereever required
mysql -u (username) -h(hostname) -p databasename > hi
> >
> > i want to dump the contents of one table into a text
> > file ... can you tell me what i've done wrong ?
>
> hi
>
> i want to dump the contents of one table into a text
> file ... can you tell me what i've done wrong ?
>
> i tried :
>
> mysqldump --opt --tables studenttable > myfile.txt
> mysqldump --opt --databases [studenttable] > myfile.txt
> mysqldump --opt database [studenttable] > myfile.txt
Just had a quick look at the mysqldump command myself and I don't see
the --opt or --database switches anywhere.
I think if you tried
mysqldump mystudentdatabase studenttable > myfile.txt
may do the trick.
- Original Message -
From: "anna soobrattee" <[EMAIL PROTECTED]>
To: "mySQL Ma
try adding a -u (--user=) and -p, this will tell the mysql
server what user you are connecting as and it will prompt you for a
password.
It could be many other things though, depending on how you have set up
your access tables. It's usually a bad idea to not restrict connections by
either host o
501 - 595 of 595 matches
Mail list logo
