Import Large MySql File into database

We have recently moved our large site to another dedicated server. Before we moved our site along with 6 other sites, we performed a "mysqldump" from the shell command line and made a .sql and a .gzip of each database.

All of the sites imported fine with no problems except for our very large site. The site is a Joomla based site with a 15mb database, most PHPMyAdmin sessions timeout when trying to import and splitting the database is not an option, since importing through the command line works without any problems. So naturally we use mysqlimport or other command line methods and it works just fine.

Not the case with site.. We have used a few GUI MySql tools for connecting to our database so that we may visually see what is hanging us up on the import process.

The database has 103 Tables

We can run a shell command and 50-53 of those tables will import and then it stops and tells us a mysql error has occured because of a duplicate entry or table.

This data is private and will need to be handled on OUR machine.

You will be given remote access from where we may type in the passwords for you and then let you do the rest while we monitor your actions. We will not pay if you violate our rules!

No highlighting, copying and paste functions will be allowed while using remoting access. We will need to communicate via MSN instant messenger while you are working on our machine. If you need to copy and paste something, tell us and we shall do so for you!

This should be a simple process for anyone experienced with MySql. Our budget is 30.00

Before we respond to your post you must place the string of numbers "556659" in the bottom of your post so we know you arent just bidding and you have completely read our project requirements.

We look forward to working with you!

Kemahiran: Linux, PHP, Sistem Admin

Lihat lagi: what is database entry, up string, string problems, simple file database, mysql data entry gui, mysql data access, data entry via remote, connecting to a mysql database, sql server gui, data entry through sql, sql mysql, sql import, remote admin, passwords, Mysql, mysql error, mysql copy, mysql admin, large data, import sql, import mysql, import database, gzip, file server, database admin

Tentang Majikan:
( 82 ulasan ) cocoa, United States

ID Projek: #83011