Importing my old database while upgrading to 3.7.0

[mitskits]

Hi all, I am running 3.6.8 patch 2 and want to upgrade to 3.7.0. My current database was created with PHP 4.3.11 and it is using mySql 4.1.22-max-log as it's reported in the AdminCP. To upgrade to 3.7.0 I need to create a new database (specifying a newer PHP version) and import my old database to the new one. My web host told me that I can do that via phpAdmin but there was a limit of 2MB per database file. My database backup file (.sql) is ~25 Mb (excluding the attachments which are stored outside the db). My questions are:

- is there a convenient way to import my old database to a newly created one as one big file? If not, what do I need to do?

- will my currently stored attachments work with the new database after importing?

Thank you very much for your help.

[Vtec44]

I was in the exact same situation when I was upgrading my 3.5.2. Thankfully, my hosting account came with a shell access so I did a mySQL dump to a folder on the server and restored to a different database server with a newer mySQL version. Since it was all on the server and I didn't need to download anything, the dump and restore took less than 10 minutes for over 200MB of just data. I went on with the upgrade using the data on the new database server once the restore was completed. My attachments are also stored outside of the database, and as long as you keep the directory structure exactly the same it should be good. It's working for me. :)

Disclaimer: I'm not sure if that's the correct way or not, but it's working for me so far.

[peterska2]

vBulletin 3.7 will run on your existing setup as the minimum requirements are the same as for 3.6. If you cant backup your database yourself, some hosts will backup and restore databases. Contact your host to see if they will do this.

[mitskits]

vBulletin 3.7 will run on your existing setup as the minimum requirements are the same as for 3.6. If you cant backup your database yourself, some hosts will backup and restore databases. Contact your host to see if they will do this.

Thanks to both for the info, I had misinterpreted the requirements.