I'm in the process of setting up mysql v5.0.24 on a new server. The
server it's replacing is running mysql v4.0.23.
I've run mysqldump to get a text file of SQL statements to read into
mysql on the new server, and everything seems to work fine until it gets
to a particular section of the
@lists.mysql.com
Subject: Moving Databases from v4.0.23 to v5.0.24
I'm in the process of setting up mysql v5.0.24 on a new
server. The server it's replacing is running mysql v4.0.23.
I've run mysqldump to get a text file of SQL statements to
read into mysql on the new server, and everything
Jimmy Guerrero wrote:
Hello,
REPEAT is indeed a reserved word in MySQL in 5.0
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
Thanks for the quick response. As it turns out, this may be a moot
point, as the database in question
Hello.
3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that mean that I
can't just move databases from a machine that was 3.23 to a machine
that is 4.1?
You can, however usually it won't work as supposed without additional
actions (like index repairing).
Curious George
Thanks for the replies so far,
I still haven't got this figured out, but I left out one important
piece of information. I'm moving 3.23 databases to a 4.1 installation.
Looking at the documentation, I see instructions for upgrading from
3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that
George [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, December 03, 2005 7:05 AM
Subject: Moving databases from backups not working . . .
Greetings all,
I've got some headaches I need to make go away over the weekend. I
used phpMyAdmin to backup some small mysql databases. (So I've got
Hello.
Login as root though mysql command line client and check
if new tables exist and if you're able to work with them.
Under what user are you working in phpMyAdmin? Does he have
some privileges on just created databases or 'SHOW DATABASES'
privilege. See:
Greetings all,
I've got some headaches I need to make go away over the weekend. I
used phpMyAdmin to backup some small mysql databases. (So I've got a
bunch of _dbname_.sql files)
I have a different machine with a newer version of MySQL (4.1.13a)
running and configured so that I can connect from
I need to move my MySQL databases to another machine.
The current machine the databases are on is running MySQL version 3.23. The new
machine is running 4.0. The machines have the same floating point format. The databases
are *very* large (several hundred tables, most around 4MB, a couple over
Ok, I've set my root password and have found (by creating a db) that
the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
I have my old system on a separate hard disk; however, mysql is not
functioning there, but I do have my databases there. Can I copy these
database to
PM
Subject: moving databases
Ok, I've set my root password and have found (by creating a db) that
the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
I have my old system on a separate hard disk; however, mysql is not
functioning there, but I do have my databases there. Can
In a message dated 10/29/03 4:18:28 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
Ok, I've set my root password and have found (by creating a db) that
the databases are stored (Mac OSX Server 10.3) in /private/var/mysql.
I have my old system on a separate hard disk; however, mysql
We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of
MySQL, it does everything as far as installing and compiling it for us. But what we
found is that is stores the databases where it wants and would like to move them but
cant seem to figure it out. Does anybody
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: David Wilson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 5:49 PM
Subject: Moving databases
We are running MySQL
How can I retain databases I created using MySql 3.23 in Mysql 4.0?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Message-
From: Bravismore Mumanyi [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2002 12:35
To: MYSQL
Subject: Moving databases
How can I retain databases I created using MySql 3.23 in Mysql 4.0?
-
Before posting, please
Hi,
Richard Idalski wrote:
I have before me what seems to be a very daunting task to someone with my
limited SQL knowledge. I'm upgrading our ad server which runs on MySQL
3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth
of databases that need to be transferred
While I haven't tested this, you might try something like...
mysqldump -h host -u userid -p database | mysql -h newhost -u
new_userid -p database
or, share out and NFS mount the new system's partition to the old system
and do a dump that way.
Just a few thoughts,
Ron
Richard Idalski
I have before me what seems to be a very daunting task to someone with my
limited SQL knowledge. I'm upgrading our ad server which runs on MySQL
3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth
of databases that need to be transferred over, and the old server lacks
19 matches
Mail list logo