Web Hosting Talk : Other Forums : Web Hosting Lounge : Argh...Newbie with MySQL

[Radon3k]

I'm a newbie with MySQL and I'm trying to import a database for a vBulletin board.

The vBulletin manual says that to restore a database you need to type "mysql -uUsername -p password < /path/to/file/"

Well what does "<" mean and how do you get it to work?

I've tried typing that in while in shell and it doesn't work.

Also, can you do this from phpMyAdmin? For some reason I can't get the mysql command to work in shell.

Thanks for any help!

[roly]

Yes you can use phpMyAdmin but you need at least 2.2.4

[Radon3k]

Ok but how do I use that command? I typed in < /path/to/file/ in phpMyAdmin but it didn't work...

What do I have to type in to get it to work?

[roly]

Originally posted by Radon3k
Ok but how do I use that command? I typed in < /path/to/file/ in phpMyAdmin but it didn't work...

What do I have to type in to get it to work?

lol phpmyadmin is in pure php, its a php script
install it from www.phpmyadmin.net
click on the db
and copy or upload the mysql schema into where it says.

[Radon3k]

Um...I know what it is, but I need to import a file called vbulletin.sql

I tried upping it but it said "no query found"...I did open up vbulletin.sql but it's so big I can't and don't have the time to copy and paste bits of it at a time. Is there another way to upload it?

[Lawrence]

Originally posted by Radon3k
I'm a newbie with MySQL and I'm trying to import a database for a vBulletin board.

The vBulletin manual says that to restore a database you need to type "mysql -uUsername -p password < /path/to/file/"

Well what does "<" mean and how do you get it to work?

Back to this one, the "<" will use your file (/path/to/file) as input to the command. So in this case, you'd be firing up the MySQL client ("mysql -uUsername -p password") and passing the SQL commands in your file as input, thus rebuilding your database ("< /path/to/file/").

[Radon3k]

Yes I did that and nothing happens, it tells me it's not a valid querry...

[Radon3k]

In fact, this is what it tells me:

You have an error in your SQL syntax near '< /usr/local/psa/home/vhosts/domain.com/vbulletin.sql' at line 1

(Of course domain.com is replaced w/ the original)

[roly]

well upload phpmyadmin to old host where vb board currently is, optimize database then try to upload to new host again

[Radon3k]

In phpMyAdmin, the "<" command is not working...I do need to type in the name of the backup file that I upped, yes? If so, then I'm doing it right but it wont' work....

[roly]

umm < isn't for phpmyadmin

[Radon3k]

Well then what do I use for phpMyAdmin?? And btw, every time I've tried that command it doesn't work either, but that's a different story....

[Lawrence]

Originally posted by Radon3k
In fact, this is what it tells me:

You have an error in your SQL syntax near '< /usr/local/psa/home/vhosts/domain.com/vbulletin.sql' at line 1

(Of course domain.com is replaced w/ the original)

Is this Windows or Unix that you're using? And if you're using Unix, which shell?

[Radon3k]

Linux with Plesk

[Lawrence]

I just checked phpMyAdmin, which is probably easier. Just select your database on the left, and you should get a screen with lots of options for your database. Scroll down to "Run SQL query/queries on database YOURDATABASE". Then there's an option for "Or Location of the textfile". Click the browse button and select the file from your computer to upload and run.

As for the command line, I don't know why "<" isn't working. I thought it was standard for all shells, but maybe I'm wrong. Try typing "bash" first to go to the bash shell, and try the command there. I normally use bash, and it certainly works there.