moving mysql db from a server to another
 

i want to move the mysql database from tho old server to a new server, but i'm not too familiary with phpmyadmin
i've exported the database from the old server and saved the .sql file to my comp.. what do i have to do next?

thx

Create a database and import it.

how do i import-it? i don't see the import option in phpmyadmin

Create the database, then click on the new database name in the left frame. Then there should be a "browse" button in the middle of the page (you might have to scroll down). Find the file on your computer. From there, you should be able to run the .sql file you saved from the other database.

If it doesn't work, you can always drop it and start again, but that should do it.

This is from memory, someone else might know the exact process.

command line baby:

mysql -uroot -p < whatever.sql

by the way, thats for a mysqldump file... not sure how phpadmin does it

ok.. i moved the ttt script database with phpmyadmin
i see all the tables in the ttt script admin area from the site of new server but someting is not ok.. the stats are frosty.. they do not count the in hits and they are not reset
what's wrong?

When you backed up the database, did you back up the structure and data, or just the structure? Make sure the data from your old server is in the new database.

i've exported the structure and data.. all the data from old server (trades, hits,etc..) are in the new database but they are frosty

when i click on a link to ttt-out.php i get this error message:

Error:
Unknown column 'blockheads' in 'field list'

anyone moved succesfuly the db of ttt script from a server to another?

mysqldump, dumping table structure and data:
"Utility to dump a database or a collection of database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). The dump will contain SQL statements to create the table and/or populate the table...."
http://www.mysql.com/doc/en/mysqldump.html

Backing up your database:
http://www.mysql.com/doc/en/Backup.html

Repairing tables within a database:
http://www.mysql.com/doc/en/Repair.html

<br><br>