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 r
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
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
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
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
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
* 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
Tom,
> I have "Database 1", table "userdata", field "username"
> I need to copy the above mentioned data to:
> "Database2", Table "chat_data", field "nick"
in phpMyAdmin 2.3.3pl1 you can accomplish this as follows:
1. Choose "Database 1" in the left frame.
2. Click table "userdata" in the left f
17 matches
Mail list logo
