Sedang Disiapkan

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Linux, PHP

Lihat lebih lanjut: 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 tables database mysql, moving table database mysql, php mysql move table, moving mysql tables, move mysql table database, mysql move tables schema, move tables mysql databases, move mysql tables linux, move table mysql, mysql move table database, move mysql view, move mysql tables, mysql moving table

Tentang Majikan:
( 13 ulasan ) Lincoln, United States

ID Projek: #114244