Moving database

--=__PartCCEFDF83.0__=
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I have a db on my development server. I am ready to move this DB into =
production. Can I just copy the files into the production server's =
mysql/data folder and have it work.=20
=20
I am trying to avoid normal SQL set up because the server is not off site =
accessible and there isn't an MySql/computer person on the site at this =
time.
=20
I can script the move to move files from a dvd to the server then almost =
no hands on * at that end.


--=__PartCCEFDF83.0__=--

Re: Moving database

Yes you can.

I do this routinely between a Windows box and a Linux production server.

Just be careful to stop your DB servers before, so that tables be closed
properly.

HTH
Ignatius

Jerry Bogren wrote:
> I have a db on my development server. I am ready to move this DB into production. Can I just copy the files into the production server's mysql/data folder and have it work.
>
> I am trying to avoid normal SQL set up because the server is not off site accessible and there isn't an MySql/computer person on the site at this time.
>
> I can script the move to move files from a dvd to the server then almost no hands on * at that end.
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Moving database

If you're crossing windows and linux, if you don't have
lowe_case_table_names, you should check for the case of your tables
names (windows sometimes hides this), and assuming both servers have
the same version, I don't see any problem on doying this.

On 4/13/05, Ignatius Reilly wrote:
> Yes you can.
>=20
> I do this routinely between a Windows box and a Linux production server.
>=20
> Just be careful to stop your DB servers before, so that tables be closed
> properly.
>=20
> HTH
> Ignatius
>=20
> Jerry Bogren wrote:
> > I have a db on my development server. I am ready to move this DB into p=
roduction. Can I just copy the files into the production server's mysql/dat=
a folder and have it work.
> >
> > I am trying to avoid normal SQL set up because the server is not off si=
te accessible and there isn't an MySql/computer person on the site at this=
time.
> >
> > I can script the move to move files from a dvd to the server then almos=
t no hands on * at that end.
> >
> >
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Moving database

Your password and user configuration, as well as hosts and many other
stuff is stored at the database called "mysql", so, to "clone" this
you just have to ensure that both servers have no compatibility issues
and just move this database (the folder) to your new server.

In fact, I noticed that if you clone the ".cnf" or in my case the
".ini" file and move the folder "data" from server to server (assuring
its compatibility of version) you get a perfect clone :) even crossing
Windows X Linux. I love this about MySQL.

On 4/18/05, Rene Harder Olsen wrote:
> Does this mean that I can move tables which contains data as well from
> destination to another? I mean another Machine, what about password and
> things like that?
> Regards
> Rene
>=20
> -----Oprindelig meddelelse-----
> Fra: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> Sendt: 13. april 2005 16:17
> Til: MySQL Win32 List
> Emne: Re: Moving database
>=20
>=20
> If you're crossing windows and linux, if you don't have
> lowe_case_table_names, you should check for the case of your tables
> names (windows sometimes hides this), and assuming both servers have
> the same version, I don't see any problem on doying this.
>=20
> On 4/13/05, Ignatius Reilly wrote:
> > Yes you can.
> >
> > I do this routinely between a Windows box and a Linux production
> server.
> >
> > Just be careful to stop your DB servers before, so that tables be
> closed
> > properly.
> >
> > HTH
> > Ignatius
> >
> > Jerry Bogren wrote:
> > > I have a db on my development server. I am ready to move this DB
> into production. Can I just copy the files into the production server's
> mysql/data folder and have it work.
> > >
> > > I am trying to avoid normal SQL set up because the server is not off
> site accessible and there isn't an MySql/computer person on the site at
> this time.
> > >
> > > I can script the move to move files from a dvd to the server then
> almost no hands on * at that end.
> > >
> > >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> >
> >
>=20
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Drehol@tdc.dk
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org