Jump to content
  • 0
Mentalist

trunk trasnfer

Question

4 answers to this question

Recommended Posts

  • 0

From Putty:

Login to putty(assuming that you using linux)

type following command

 

mysqldump -u root -pPASSWORDHERE database > filename.sql 

it will create filename.sql in the folder you are in, download that filename.sql to your pc, connect to your new vps, transfer filename.sql to there.

then open putty and type following command

mysql -u root -pPASSWORDHERE database < filename.sql

 

 

OR

 

 

If using PhpMyAdmin:

select a database, and export the database by button located at top, choose appropriate options, and export it,(file will be downloaded.)

 

 

On New Host:

Login to phpmyadmin,create database, select that database, Press Import button located at top(besides Export Button), Choose your sql file and submit, and your database will be transferred.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.