Login

Contact

You can leave a message using the contact form below.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.
Home › Transferring MySQL database to another server with the add/change the prefix

Transferring MySQL database to another server with the add/change the prefix

Hide all descriptions
Submitted by Marat Farkhulin on Saturday, 04.10.2010
tags:

It's enough to make a backup of the database on the source server, then open the backup in the editor and using the command "Find and replace" to make the following changes:

CREATE TABLE ` changing to CREATE TABLE `myprefix_
INSERT INTO ` changing to INSERT INTO `myprefix_

Where myprefix_ - is the desired table prefix database. Just occasionally you may need to rename these tables here:

REPLACE ` changing to REPLACE `myprefix_
ALTER TABLE ` changing to ALTER TABLE `myprefix_