Yes,
You are right..
So, Jason you should after you move the data, import this file to fix the ids.
# cat
/opt/jffnms/docs/upgrade/mysql/jffnms-0.7.8-to-0.7.9.mysql.diff.x_fix_internal_ids
ALTER TABLE interface_types AUTO_INCREMENT = 10001;
ALTER TABLE interface_types_fields AUTO_INCREMENT
> There should be no problem on doing that.
> And you will not loose any data if you use mysqldump correctly. It will generate
> a file with a dump of all the required sql commands to get the same database, so
> you can use that to regenerate your windows mysql.
Are you not forgetting the
Jason,
There should be no problem on doing that.
And you will not loose any data if you use mysqldump correctly. It will generate
a file with a dump of all the required sql commands to get the same database, so
you can use that to regenerate your windows mysql.
Then change the db server configu
Install Windows based MySQL on the Win2k box, and then copy the "data"
dir for mysql, you dont even need to do a dump. This way you dont need
to worry about importing, and exporting, creating users and and tables.
This is what we did, and it worked perfectly. Then just change the IP in
the setu
This should pose no problem, as in all cases, it's just speaking to
MySQL directly. Use mysqldump to dump the database, and to reimport
it.
http://dev.mysql.com/doc/mysql/en/mysqldump.html
--falz
On Thu, 7 Oct 2004 10:42:26 -0400, Jason Humes <[EMAIL PROTECTED]> wrote:
> Hi
> So I'm thinking
Hi
So I'm thinking of moving the mysql database off of my JFFNMS box and
putting it on a w2k box. Is this possible, having a JFFNMS running on linux
and the mysql running on windows? Also, it is easy to move my existing data
from the JFFNMS mysql to the windows mysql? Is this possible without lo
