Thread: Moving to a new Server

I am moving my site to a new server and I wanted to know how to transfer my database without loosing any of my members.

has anyone done this before.

Oh and by the way...when I download a backup of my database, I would try to unzip it and it asks me to give an extention (database.___),is this normal?

Try

PHP Code:

.sql 


How did you make your backup ?

If you do a backup via the cpanel, you should also be able to do a restore the same way (hopefully) Just upload the file, and it should be able to uncompress it.

I did decide to try myphpadmin and the problem is that the sql and phpadmin versions are different.

current: myphpadmin 2.9.0.2
sql 4.1.10
my new: myphpadmin 2.7.0-pl2
sql 4.0.16

I get an error when I try to import the old DB up to the new DB.
here is the error message below.

*****************error message***********************
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 20, 2007 at 11:34 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `*******_*******`
--
-- --------------------------------------------------------
--
-- Table structure for table `Admins`
--
CREATE TABLE `Admins` (

`Name` varchar( 10 ) NOT NULL default '',
`Password` varchar( 10 ) NOT NULL default '',
PRIMARY KEY ( `Name` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;



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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5

*****************end error message***********************

How can I get this done.

Hi Everyone!

I have some problem that backup/export database from my localhost to the other web sever, but......

(1) I backup from dophin admin panel than save to Desktop, and I get the file name call :"CA5C4FTP"

(2) Than I use myAdminphp and try to import "CA5C4FTP" file, but all shows "ERRO"

This should be a very basic question, but couldn't find more details in Modmysite. Anyone could point out this solution? Thank you very indeed.

In the sql file you have download is there a statement to create the database.
Make sure the database already created and that you are executing on the correct database.
Also do you have drop statements in your backup.

use a mysql client like
http://www.webyog.com/en/ [the free version should be enough to meet your needs]

Have a ftp client like cuteftp read.

steps
1] Download all you dolphin files on your computer if you have done modifications so than you can transfer them across using a ftp client as simple as drag and drop.
2]If you use sqlyog you can use a ssh tunnel to connect to you mysql database.
than right click on the database you want to backup and select backup and mysql dump.
than connect to your new server and right click on the database you have created and click resort from mysql dump.

must say very easy

3] Make sure you back up id_img folder as well.

Try it now you should have not problems.

Thank you ijk, That's very helpful, I will try and hope it works.


Thanks again!

Code:

ENGINE = MYISAM DEFAULT CHARSET = latin1;

You can open your .sql dump file in a programmers editor and remove the statements that are affecting your import.

Smoge