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 hasn't
t; To: mysql@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
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 mysq
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 Georg
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 mean
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:
http://dev.mysql.com/doc/refm
rious George" <[EMAIL PROTECTED]>
To:
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. (S
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 t
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 4G
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, my
sday, October 29, 2003 2:23 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
> fun
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 their
2391
[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
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 hav
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
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 thre
While I haven't tested this, you might try something like...
mysqldump -h -u -p | mysql -h -u
-p
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 wrote:
>
> I have before me what seems to be
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
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
eno
19 matches
Mail list logo
