Moving mysql databases

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Moving mysql databases

Duane Hannan
I’ve set up a new server—Mac 10.10.4 (running Apache from the terminal) with a new MySQL download and a new install of Lasso 8.6.  It’s working the way I expect.  I have several databases that I want to move from the old server to the new server.  I dragged and dropped one’s folder between the two machines' mysql folders, and I made Lasso recognize it by declaring the appropriate host and restarting the site. Enabling and assigning the database at siteadmin.lassoapp allowed me to add, update, delete and so on.

I realize that it’s possible to move the database folders using terminal commands, but in using this method are they then moved as enabled and assigned?

Dragging and dropping the rest of the databases would be easy, but is there a way to automate the enabling and assigning?  I have quite a few to move, and enabling and assigning is a bit tedious.


Thanks,

Duane Hannan
WWG Schools




#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Moving mysql databases

stevepiercy
I'm surprised that drag-and-drop would work.  It raises concerns
about different MySQL server versions, system users and
permissions, and MySQL internal databases.

My preferred way to migrate databases between machines would be
to use Navicat or Navicat Premium.  Sync all the dbs with a few
clicks and keystrokes.  It's worth every penny.

There's also MySQL Workbench.  I stopped using it in favor of Navicat.
http://dev.mysql.com/downloads/workbench/

Else, you can use the mysqldump command line utility to backup
and restore databases.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

There are probably a few other ideas to consider.

--steve


On 8/2/15 at 6:43 PM, [hidden email] (Duane Hannan) pronounced:

>I’ve set up a new server—Mac 10.10.4 (running Apache from
>the terminal) with a new MySQL download and a new install of
>Lasso 8.6.  It’s working the way I expect.  I have several
>databases that I want to move from the old server to the new
>server.  I dragged and dropped one’s folder between the two
>machines' mysql folders, and I made Lasso recognize it by
>declaring the appropriate host and restarting the site.
>Enabling and assigning the database at siteadmin.lassoapp
>allowed me to add, update, delete and so on.
>
>I realize that it’s possible to move the database folders
>using terminal commands, but in using this method are they then
>moved as enabled and assigned?
>
>Dragging and dropping the rest of the databases would be easy,
>but is there a way to automate the enabling and assigning?  I
>have quite a few to move, and enabling and assigning is a bit tedious.
>
>
>Thanks,
>
>Duane Hannan
>WWG Schools
>
>
>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.StevePiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>