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
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
> -Original Message-
> From: Kurt Cypher [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 09, 2006 3:13 PM
> To: mysql@lis
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
Go this man http://www.silisoftware.com/scripts/?scriptname=backupDB
the power scripts which back up your db mysql in minute and you can download
throught ftp.
Please feel free to reply to this email if you have additional questions or
concerns
???
01-7499093
? ??
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
that will be recognized very well, just check the file ownership after
copying directory and files. all the data directory and files should be
owned by mysql only
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 29, 2003 2
Off the top of my head:)
In the my.cnf file under the [mysqld] section add the following line:
datadir= /path.to/new/datadir
Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this
is a straight copy). Restart mysql.
HTH
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMA
If it on the same system just stop the old mysqld and stat the new one
pointing at the same mysql/var/.
OR copy the table across useing cp or mv...it should just work (did for
me)...
This is all unless you are useing a new table format but you could use ALTER
TABEL TYPE..
Simon
-Original
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
12 matches
Mail list logo
