syntax to use
TA> near 'mysql
TA> dump --help' at line 1
You myst use mysqldump command from you shell, not from mysql.
TA> -Original Message-
TA> From: J.R. Bullington [mailto:[EMAIL PROTECTED]
TA> Sent: Tuesday, June 20, 2006 11:32 AM
TA> To: mysql@lists.mys
On Tuesday 20 June 2006 21:37, Thomas Amundsen wrote:
> I'm running MySQL server 5.0...???
>
> mysql> mysqldump --help;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'mysql
> dump --h
m: J.R. Bullington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 11:32 AM
To: mysql@lists.mysql.com
Subject: RE: Copy database to a file
The command is "mysqldump"
Here's the man file on it:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
-Original Message-
The command is "mysqldump"
Here's the man file on it:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
-Original Message-
From: Karl Larsen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 3:09 PM
To: mysql@lists.mysql.com
Subject: Copy database to a file
I have been reading the Reference and saw how to convert my database
tables and stuff to the words that made them and puts it into a file.
But now I need it I can't find it.
If you know how please send along how or a page(s) in the Reference.
Karl
--
MySQL General Mailing List
For list
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html
http://dev.mysql.com/doc/mysql/en/Moving.html
Luke Vanderfluit wrote:
> Hi.
>
> I'm using 4.0.18 and for legacy reasons I can't upgrade that.
>
> However I'm upgrading the database to a new s
You could also try the mysqlhotcopy binary, if it exists in your bin/
directory. I don't remember when that came out, but you might have
it. You don't have to stop the instance for that.
-Sheeri
On 10/20/05, Clyde Lewis <[EMAIL PROTECTED]> wrote:
> You could copy the entire mysql directory stru
You could copy the entire mysql directory structure to an isolated area
on disk. This will involve stopping the instance though.
Luke Vanderfluit wrote:
Hi.
I'm using 4.0.18 and for legacy reasons I can't upgrade that.
However I'm upgrading the database to a new schema.
I want to copy the da
Hi.
I'm using 4.0.18 and for legacy reasons I can't upgrade that.
However I'm upgrading the database to a new schema.
I want to copy the database before I make changes to the schema, so that
if anything goes wrong, I can revert back.
I have a dump file of the database but that is around 5GIG,
mysqldump
Maru, Mulugeta wrote:
How can I copy all the tables in a database that I am developing using 5.0 to a production database that uses 4.1.8? All the tables are InnoDB tables.
Regards,
Maru
--
|...|
| _ _|Vi
How can I copy all the tables in a database that I am developing using 5.0 to a
production database that uses 4.1.8? All the tables are InnoDB tables.
Regards,
Maru
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
In a message dated 9/30/03 3:13:59 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> What if you have InnoDB tables?
I don't. ;-)
But I'd certainly like to know other strategies.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
At 14:54 -0400 9/30/03, [EMAIL PROTECTED] wrote:
In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
HI List,
Using version 4.0.15
I'm trying to copy a database. Copy db1 to (new) db2.
So I created db2.
And then tried the following and got
In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
> HI List,
>
>
>
> Using version 4.0.15
>
>
>
> I'm trying to copy a database. Copy db1 to (new) db2.
>
>
>
> So I created db2.
>
>
>
> And then tried the following and got the s
"DePhillips, Michael P" <[EMAIL PROTECTED]> wrote:
>
> Using version 4.0.15
>
> I'm trying to copy a database. Copy db1 to (new) db2.
>
>
> So I created db2.
>
> And then tried the following and got the subsequent errors.
>
> # mysqldump --add-drop-table db1 | mysql db2
>
> ERROR 1064 at li
HI List,
Using version 4.0.15
I'm trying to copy a database. Copy db1 to (new) db2.
So I created db2.
And then tried the following and got the subsequent errors.
# mysqldump --add-drop-table db1 | mysql db2
ERROR 1064 at line 399: You have an error in your SQL syntax near
'
William IT wrote:
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
Try 770
Mysql needs to be able to scan the directories to find tables.
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
My
At 11:54 +0800 6/11/03, William IT wrote:
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
We don't know.
Did the server start up correctly?
If it did, h
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
John Wards <[EMAIL PROTECTED]> wrote:
>
> I have a a database lest say called "test" which is about a gig in size. I
> want to take a copy of that database and call it "test2" and have it running
> on the same server.
>
> I could just do a dump and then insert the dump back in but this seems a
> I have a a database lest say called "test" which is about a gig in size.
I
> want to take a copy of that database and call it "test2" and have it
running
> on the same server.
> I could just do a dump and then insert the dump back in but this seems a
> rather long way of doing it. I had a searc
Hi mysql list,
I have a a database lest say called "test" which is about a gig in size. I
want to take a copy of that database and call it "test2" and have it running
on the same server.
I could just do a dump and then insert the dump back in but this seems a
rather long way of doing it. I had
* Tom Nickels
> I have "Database 1", table "userdata", field "username"
>
> I need to copy the above mentioned data to:
>
> "Database2", Table "chat_data", field "nick"
>
> I have no clue how to do it! Can anybody tell me the string?
If the destination table already exist, something like this:
IN
ot;, click "Save".
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Tom Nickels" <[EMAIL PRO
Hi everybody,
I am new on mysql. I use phpadmin for adminstration.
My problem:
I have "Database 1", table "userdata", field "username"
I need to copy the above mentioned data to:
"Database2", Table "chat_data", field "nick"
I have no clue how to do it! Can anybody tell me the string? Thanks f
Hi everybody,
I am new on mysql. I use phpadmin for adminstration.
My problem:
I have "Database 1", table "userdata", field "username"
I need to copy the above mentioned data to:
"Database2", Table "chat_data", field "nick"
I have no clue how to do it! Can anybody tell me the string? Thanks f
26 matches
Mail list logo