I have to move from my current hosting plan to another one for a better performance and as well as bigger space. I have some difficulty in bringing up large database into the new host. It seems so large that i have to do it manually 1000 records each time. Have you had any issue with moving host and how do you manage it?
Hi. If both hosts are using cPanel then you can try to ask your new host to copy your whole account from your old host with all the data, e-mails, DBs etc. It should not take much time (again - if both hosts are on cPanel).
uptime, thanks for the info (I din't know that is possible) However, my old host was ensim (They lack lots of feature) hence i decided to move on ...
If you have problems with MySQL DB import only then you can generate a full DB dump via phpMyAdmin at your old host, upload the dump file to your new host and: a). ask them to import the file for you via the mysql command line or b). do that yourself if you have SSH access.
I know you said you don't have cpanel, but possibly there is a way to do this as well with your control panel: Download MySQL Administrator. There is a Mac OS X, Windows, and Linux version, so choose your os version. You can optimize, check tables, and restore/backup using MySQL Administrator. Step 1. Login to cPanel. Step 2. Go to MySQL Databases and add your IP address to the bottom, where it states Access Hosts. The IP is your internet IP. WhatIsMyIP.com can tell you what your internet ip is. Step 3. Start MySQL Administrator and connect. Use the settings: Sever host: your domain name Port: 3306 Username: the username for your database, usually cpanelusername_user Password: the password for the database Step 4: Go to Catalogs and choose your database. From there it should be pretty self-explanatory. Note: Connections will be slower than phpMyAdmin, so you probably only want to use this when you need to restore or backup a large file and probably off peak hours. Last but not least you can use a script named BigDump.php, you can find this on hotscripts.com or try Google.