Search results for query: *

Its been a while since I fixed this, and I can't remember if that was the method I used, but I was a relatively new user when it came to MySQL and I ended up alright. I'm not sure if that helps you out at all but good luck! --Greg

That was exactly it! I should have know. I didn't create this database, sorta inherited it, so now I have to go about fixing everything! Thanks again, Greg

So I've finally gotten all of my databases backed using mysqldump. I'm trying to load them back in and everything seems to go fine until I get this error for this chunk of code: mysql> CREATE TABLE newsSync ( -> id int(10) unsigned NOT NULL auto_increment, -> artist int(10)...

Thanks a bunch! One more quick question, what is the path that mysql takes? When I'm in "mysql>" is the path from the location of mysql or from the root? I running RedHat Linux so the path to mysql is /usr/bin/mysql. If I put the file in /usr/bin/file.sql does that mean I write the code as...

So I used phpMyAdmin to export about 6 databases into on .sql file. All of the tutorials I've read about restoring databases talk about restoring into a current db. If I have 6 dbs in the file, what is the correct restoration command? I'm working the restore on the command line, not...

yeah, thats actually the tutorial that I was doing when I ran into the trouble. The trouble is, that assumes that you already have a root user. Apparently I don't and I have no idea what user is acting as root. I'm guessing Plesk is using some sort of root since it can still create databases...

Okay, so I just got a small dedicated server (running RedHat Linux and MySQL 3.23) and I've been working at getting everything setup. Most of what I've been administering has been through Plesk up until this point but when I decided to move my databases over Plesk's version of phpMyAdmin just...