Skip to content
  • About
  • Books to Note
  • Contact US

Gullele's Corner

breath in 0's breath out 1's

  • About
  • Books to Note
  • Contact US
  • My Bookmarks
  • PHP Programming
Home move mysql

How to move MySQL database from one server to another

First access the files of the database (MYI, MYD, FRM) from the existing database by going to
/var/lib/mysql/(your database) – This path holds true for ubuntu

Then go to the new server and put it in the same place

/var/lib/mysql/(your database).
restart your server and mysql then view it through phpmyadmin.

Posted by gullele / April 10, 2009 / 1 Comments / Tagged with move mysql, MySQL, one to another / Posted in MySQL

Recent Posts

  • Share file from Windows to Mac OS
  • Cannot read property setState of undefined
  • See the binding parameters in JPA query – java logs
  • Hibernate Not Creating table from Entity – Java Issue
  • find longest word in the sentence

Recent Comments

  • aj on The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  • gulleman on jQuery Select Option from Json
  • Tesfaye Gari on jQuery Select Option from Json
  • Fred on Date Picker in jQuery misses next and prev arrow. How to add arrow on jQuery date picker
  • ram on Browser automatically sorting json object based on key problem..

Categories

  • Algorithm (19)
  • Amazon EC2 (8)
  • Apache (5)
  • Arduino (1)
  • ASP.NET (6)
  • Assembly (4)
  • Bash/Shell scripts (4)
  • C (6)
  • Debugging (1)
  • Docker (2)
  • Doctrine (7)
  • Facebook Marketing (6)
  • Generic Programming Topics (9)
  • Git (6)
  • Hibernate (11)
  • iPhone (1)
  • Java Web (54)
  • JavaServer Faces (12)
  • jQuery/JavaScript/CSS (38)
  • Mac OS (27)
  • maven (4)
  • Mercurial (6)
  • mobile development (1)
  • Mockito (2)
  • MongoDB (3)
  • MS SQL Server (7)
  • MySQL (31)
  • node (10)
  • PHP (83)
  • PhpUnit (1)
  • postgres (4)
  • Programming Tools (17)
  • PuPHPet (2)
  • Raspberrypi (3)
  • React JS (1)
  • Ruby on Rails (RoR) (6)
  • Spring/boot (5)
  • Symfony (16)
  • Ubuntu (35)
  • XML/XSL/XSLT (2)
  • YII PHP Framwork (1)

Tags

access algorithm apache array cache Change composer database doctrine EC2 Eclipse error example Facebook file files git hibernate image install java javascript jQuery js JSF json Linux mac maven mongo multiple MySQL node nodejs not PHP port problem request ssh symfony tutorial Ubuntu vagrant version

side-ad

Tags

access algorithm apache array cache Change composer database doctrine EC2 Eclipse error example Facebook file files git hibernate image install java javascript jQuery js JSF json Linux mac maven mongo multiple MySQL node nodejs not PHP port problem request ssh symfony tutorial Ubuntu vagrant version

Recent Posts

  • Share file from Windows to Mac OS
  • Cannot read property setState of undefined
  • See the binding parameters in JPA query – java logs
  • Hibernate Not Creating table from Entity – Java Issue
  • find longest word in the sentence

Recent Comments

  • aj on The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  • gulleman on jQuery Select Option from Json
  • Tesfaye Gari on jQuery Select Option from Json
  • Fred on Date Picker in jQuery misses next and prev arrow. How to add arrow on jQuery date picker
  • ram on Browser automatically sorting json object based on key problem..

Categories

  • Algorithm (19)
  • Amazon EC2 (8)
  • Apache (5)
  • Arduino (1)
  • ASP.NET (6)
  • Assembly (4)
  • Bash/Shell scripts (4)
  • C (6)
  • Debugging (1)
  • Docker (2)
  • Doctrine (7)
  • Facebook Marketing (6)
  • Generic Programming Topics (9)
  • Git (6)
  • Hibernate (11)
  • iPhone (1)
  • Java Web (54)
  • JavaServer Faces (12)
  • jQuery/JavaScript/CSS (38)
  • Mac OS (27)
  • maven (4)
  • Mercurial (6)
  • mobile development (1)
  • Mockito (2)
  • MongoDB (3)
  • MS SQL Server (7)
  • MySQL (31)
  • node (10)
  • PHP (83)
  • PhpUnit (1)
  • postgres (4)
  • Programming Tools (17)
  • PuPHPet (2)
  • Raspberrypi (3)
  • React JS (1)
  • Ruby on Rails (RoR) (6)
  • Spring/boot (5)
  • Symfony (16)
  • Ubuntu (35)
  • XML/XSL/XSLT (2)
  • YII PHP Framwork (1)

© Copyright 2025 Gullele's Corner • Designed by MotoPress • Proudly Powered by WordPress