MySQL error

[Unreal Player]

Hey its you again!

Well I did get further.

My problem is my sql file is 300mb and I dont know how to do the SSH stuff so i was doing it manually but after awhile it got tiresome (im a moron ) Then since I had some tables there, including the users. I tried doing that but to no avail.

Database error in vBulletin:ImpEx Source 3.0.5:

Invalid SQL:
SELECT * FROM phpbb_users
ORDER BY user_id
LIMIT 0,500
mysql error: Unknown column 'user_id' in 'order clause'

mysql error number: 1054

Date: Saturday 08th of January 2005 07:07:47 PM
Script: http://www.multiconsole.com/forums/impex/index.php
Referer: http://www.multiconsole.com/forums/impex/index.php
Username: Unreal Player

[Steve Machol]

You will need to completely restore the phpBB database in order to do the import. Here again are the instructions for restoring a database:

http://www.vbulletin.com/docs/html/m...ce_ssh_restore

If you have specific questions about this processs, then please ask.

[Unreal Player]

Ok, that requires you to upload your sql backup first right? My problem is I tried this before(for a different method though, not that one) and it took like 4 hours. It took up alot of space so after the method did not work i deleted it. So is there an easier/quicker way of doing this?

And when it says DIRECTORY/TO/BACKUP or whatever, can that be on your local computer? Or does it have to be uploaded onto the site

[Dream On]

how do u take the back up it is backup.sql or the full back up come with tar ?


upload it in your dir.. and contact your company let them to Restore you back up in 2 sec

[Unreal Player]

It's SQL

with the import file do i need to import all of the tables? I just really want the users and their post counts. And I can copy that from the sql file, the user tables. But it's giving me an error with their ID'S?

[Dream On]

then if u dont no how to make it with the SSH try to contact your company let them do it for u ..

or maybe there is easy way for u ...... open the SQL and start takeing table by table like

phpBB_user take the allllllllllllll databse in phpBB_user and so on .. maybe this is the easy way for u ..

[Unreal Player]

How can I tell them to do it when the file is on my own computer

[Dream On]

upload it in your ROOT dir and contact them tell them that u need to Restore your databse and tell them u have upload the file in your dir..

so they have full access andthey can get it ..