can't import sql dump to new database for backup i have a site on drupal. I want to make a copy of that site so as to be able to make changes to the site without the fear of loosing something.

I have problem with the database. I export it in spl format. The size is about 100 MB. When i try to import it to the newly created database it says it is in progress but nothing is happening. The import is not proceeding.

I tried to transfer each table separately but when i reach a table that it is 36 MB (locale_sources) it shows it is in progress but nothing is happening.

Everything is done through phpmyadmin.

Can anyone suggest anything?

Thank you.
You can use mysql on the command line to avoid timeouts when updating big dbs.

Example:

mysql --password=yourpw --user=name --default-character-set=utf-8 db_name &lt;your_dump.sql


See mysql -? or the manpage for more options.