I want to import my backuped db (3.2M) in my remote db.
The site and db are in Norway and i'm Romania. I have FTP, shell, phpMyAdmin account.
I manage the db through phpMyAdmin 2.3.3pl1
And the db is MySQL 3.23.51

in phpMyAdmin when I click on my db name and then SQL tab ...i select my backup file from my hdd and i wait to upload the file (64 kbps/s bandwidth) .. but the upload doesn't finish properly. The progress bar of IE goes up to 100% but didn't refresh it. And the upload is not done.

I tried with Opera 6 and after I click to start the upload i get an error "Transmission error - http://mysqlurl.com/read_dump.php".

Is other way to import my backup db?

You may have to break it up into pieces.
Open your saved sql file in Notpad or Ultraedit or Editplus would be better.
You'll have to go through and selst a portion ata time, copy and paste to new file, save as file1.sql, next section, copy and paste to new text file, save as file2.sql
Takes some time, but with Databases that are a little bigger, phpmyadmin craps out.

Example. There are some 100 Database tables, you may only be able to uplaod 20 ata time cutting the ONE big sql file you have there into 5 smaller sections of it :-)

mikem

thank you once more if u don't have enough thanks

it worked even i spend more than 1h...
i had some problems importing some big tables even tryed with 1 sigle table like *posts_text, *search_results or *search_wordlist.

nut it worked nicely...

thanks again