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" <[EMAIL PROTECTED]> 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.
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
