Quick Login
A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.
Please welcome our newest member, yatoula!
Spice up your web site with the ultimate community message board solution!
Fake Id'sGet fake Id's made right now!
vBSEOSearch Engine Optimization for your VBulletin Forum.
AdminFusion
»
Moving database files to another server
02-21-2008, 06:15 PM
| #1 |
| | |||||
| Title: Lurker
Join Date: Feb 2008 Posts: 2  | Moving database files to another server I have everything moved over from one server to the next aside from my 400-something posts and my members. How do I move them over? I am using 1and1.com. They're pretty decent and I have access to phpMyAdmin. I have tried exporting the database files from my other server and then importing them into the new one (not sure if that's what I needed to do or not) and this is the error I get... SQL query: -- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: db0000.perfora.net -- Generation Time: Feb 21, 2008 at 12:56 PM -- Server version: 5.0.51 -- PHP Version: 4.3.10-200.schlund.1 -- -- Database: `db228880000` -- CREATE DATABASE `db228880000` DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci MySQL Said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_german2_ci' at line Last edited by tsg; 02-21-2008 at 06:30 PM. Reason: Adding error report  | ||||
| |
|
02-24-2008, 09:24 PM
| #3 |
| | |||||
| Title: Member
Join Date: Dec 2007 Posts: 136 Location: Ringgold, GA  
| How large is the database? Do you happen to have access to SSH to prepare a proper dump of the database SQL? Feel free to PM me if you're still having issues.
__________________ - AirborneFive - Simplified Web Hosting - First Month is 100% Free - 60 Day Money Back Guarantee - 99.99% Network & Server Uptime Guarantee | ||||
| |
|
02-25-2008, 03:25 PM
| #4 |
| | |||||
Title: www.Centicero.com
Join Date: Jan 2006 Posts: 1,016 Location: Devon, United Kingdom   
| Just to let you know - the maximum database size you can have with 1&1 is 100MB. If you're moving to them, and the database is over 100mb, then there will be problems. | ||||
| |
|
05-23-2008, 07:46 PM
| #5 |
| | |||||
| Title: Rookie
Join Date: May 2008 Posts: 18 | Try doing a dump from shell as previously recommended, and report back. | ||||
| |
|
06-02-2008, 11:09 PM
| #6 |
| | |||||
| Title: Rookie
Join Date: May 2008 Posts: 25 | If you are using Cpanel, create the database. Do not add tables, just import the database from your old server. What you do is, save the database from your old server to your PC and then use the import future to import the tables and data. You should do this via phpadmin. Make sure the database is empty before doing the import if not you will get error message. | ||||
| |
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 50+ Databases With Resell Rights Cheap | SKULL | Buy and Sell | 0 | 01-12-2008 09:23 PM |
| Lots of Free Databases! | SKULL | Buy and Sell | 0 | 09-24-2007 03:37 PM |
| 54 Databases With Resell Rights For 25 Posts | SKULL | Buy and Sell | 19 | 06-16-2007 03:46 PM |
Linear Mode
