SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Copy Database

Hybrid View

  1. #1
    SitePoint Zealot
    Join Date
    Feb 2011
    Location
    Colorado, USA
    Posts
    119
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Copy Database

    I have a database on my tower that I need to try to copy to my laptop. I have mysql workbench on both machines. Any way to copy the entire scheme from the tower to the laptop?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by dxm31 View Post
    I have a database on my tower that I need to try to copy to my laptop. I have mysql workbench on both machines. Any way to copy the entire scheme from the tower to the laptop?
    use mysqldump to create an sql backup

    then run the sql into your target database
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Feb 2011
    Location
    Colorado, USA
    Posts
    119
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks r937, this was the first time I've needed to do this. I figured it out using the admin options in Mysql workbench.

  4. #4
    SitePoint Member
    Join Date
    Apr 2013
    Location
    Seattle, WA
    Posts
    15
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Damn why don't I think of stuff like that....backup and install from backup on new db....

    Good stuff.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •