Move MySQL tables to new MySQL db

I need 3 large MySQL tables moved to another server. The table sizes are 20MB, 25MB & 360MB.

60% of the 360MB table is attributed to Index length. Is it possible to move just the data and NOT the index? If so it could be re-indexed if needed once in the new database.

I have remote access to the current and new MySQL databases as well as phpMyAdmin. However, I don’t have shell access to either.

I need someone who knows how to work around the memory/runtime server limits.

Taidot: tiedonsyöttö, tietojenkäsittely, Linux, PHP

Näytä lisää: mysql move table, mysql move large table, mysql move table schema, mysql move database, move mysql table, mysql db, mysql data access, indexed data, mysql move table server, move data mysql, mysql moving data release, mysql move archive tables, move mysql mysql, move tables database mysql, moving table database mysql, php mysql move table, moving mysql tables, move mysql table database, mysql move tables schema, move large tables server mysql, move tables mysql databases, move mysql tables linux, move table mysql, move mysql data mysql database, mysql move table database

Tietoa työnantajasta:
( 13 arvostelua ) Lincoln, United States

Projektin tunnus: #114244