I used phpMyBackup (http://sourceforge.net/projects/pmbackup/) to
compress my mySQL database into 1 tar.gz file. My old hosting provider
uses MySQL 4.1.12-standard. But my new hosting provider uses mySQL
4.0.3-standard.
I tried to import my database by phpMyAdmin, phpMyBackup and navicat..
But all of them couldn't import my db because my Db's version is newer
than my Server's version (as you see above).
That's my big problem because I want to import it ASAP!
I want to find some script that can do it for me. Or some software can
convert back my DB file to MySQL 4.0.3-standard.
Thank you

---

Request for Question Clarification by pmrozik-ga on 05 Sep 2005 05:59 PDT

Hi!

Can you connect to the old providers' server via a tool like PuTTY?
I'm assuming that you use Windows. If you can connect to the server
and access your database from there, then please download PuTTY at:

PuTTY Download Page
[http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html]

If you can do this, please tell me. 

You will need to use mysqldump in order to do a backup and this should
allow for a flawless transition to the new version of the MySQL
engine. There's no script, but it's a pretty straight forward
procedure. First tell me if you can connect to the server and access
the database and then I'll provide you with further details and walk
you through this, and if it works then I'll post the full answer.

pmrozik-ga

---

Clarification of Question by pluzbooks-ga on 05 Sep 2005 19:55 PDT

What a pitty that I've already stopped my account with the old-provider.
I only have the backup file of my database.

---

Request for Question Clarification by pmrozik-ga on 06 Sep 2005 06:23 PDT

Hello again,

In that case, let's try something else. You will need a MySQL 4.1.0 or
higher installation on your system, which you can download from this
location:

MySQL 4.1 downloads
[http://dev.mysql.com/downloads/mysql/4.1.html]

Alternatively, you could simply make use of a server that has MySQL
4.1.0 or higher installed.

Once it is installed, you will need to:

1. Extract your database from the tar.gz file using the following command:
'tar -zxvf databasename.tar.gz'
2. Attempt to convert the database on your system with this command:
'mysqldump --create-options --compatible=mysql40 db_name > dump_file'
3. Finally, upload your database to your new hosting provider and run
the following command on the server:
'mysql db_name < dump_file' where dump_file is the file you created in step 2

Please tell me if this works.  

pmrozik-ga

mail me t28680056(at)gmail.com
I will try to help you on this.

Can you install the same version of MySQL and phpmyadmin on your
computer at home to import the databases and export them again in a
format the your new provider can use.