moving mysql db from a server to another - GoFuckYourself.com

alex79 · 09-09-2003, 02:37 AM

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

Mr.Fiction · 09-09-2003, 02:44 AM

Create a database and import it.

alex79 · 09-09-2003, 02:46 AM

Quote:

Originally posted by Mr.Fiction
Create a database and import it.

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

Mr.Fiction · 09-09-2003, 02:52 AM

Quote:

Originally posted by alex79

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.

tical · 09-09-2003, 02:52 AM

command line baby:

mysql -uroot -p < whatever.sql

tical · 09-09-2003, 02:53 AM

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

alex79 · 09-09-2003, 03:08 AM

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?

Mr.Fiction · 09-09-2003, 03:29 AM

Quote:

Originally posted by alex79
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.

alex79 · 09-09-2003, 03:34 AM

Quote:

Originally posted by Mr.Fiction

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

alex79 · 09-09-2003, 03:49 AM

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?

MagicksAntics · 09-09-2003, 07:13 AM

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>

09-09-2003, 02:37 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	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

09-09-2003, 02:44 AM	#2
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	Create a database and import it. __________________ Don't be lazy, protect free speech: ACLU \| Free Speech Coalition \| EFF \| IMPA

09-09-2003, 02:52 AM	#5
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	command line baby: mysql -uroot -p < whatever.sql __________________ 112.020.756

09-09-2003, 02:53 AM	#6
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	by the way, thats for a mysqldump file... not sure how phpadmin does it __________________ 112.020.756

09-09-2003, 03:08 AM	#7
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	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?

09-09-2003, 03:49 AM	#10
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	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?

09-09-2003, 07:13 AM	#11
MagicksAntics Confirmed User Join Date: Feb 2002 Location: Everywhere Posts: 455	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>