Re: mysql

This is a question that is better directed to the mysql mailing list, not php. It is also self evident in the manual. But, here is the short answer. Standard mysql tables are in ISAM format (pre 3.23 versions of mysql) which is not directly portable between machines. MyISAM tables are. On linux, in mysql ALTER TABLE tablename TYPE MYISAM; // do this foreach table in the database you are moving. Then try copying the tables over. If that still doesn't work. Then from the command line: Mysqldump databasename > mydatabase.sql Which will dump to text, the database structure and all the data. Then, on windows, you simply: Mysqladmin create databasename Mysql -u user -p password < mydatabase.sql And database will be recreated. You should really buy a good book on mysql and learn about backing up your databases. On 4/3/01 9:07 AM, "Glenda Robalino" <g_robalino@hotmail.com> wrote: > Hi > I have created my database in mysql in linux, but i nedd my aplication, > including the database in windows, I tryied to copy, but i had problems with > the database... > all the tables are copie.. i could see the tables, but i cant make selects, > inserts.... > > what could i do to copy well the database?? > > thanks ciao > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com. >