B4J Question Jrdc - where is the Database ?

[derez]

I want to move a MySQL Database from one pc to another. Where are the database files located ?

 

[sorex]

I think it's easier to use the phpMyAdmin export tools to make a backup and restore it on the new one. It will create the tables and everything for you.

 

[Erel]

Note that jRDC is only a connector. So the question is where is the MySQL database. MySQL database is not a simple file such as SQLite databases. The proper way to move it is by making a dump (backup) and restoring it.

 

[derez]

I think it's easier to use the phpMyAdmin export tools to make a backup and restore it on the new one. It will create the tables and everything for you.

The size of the exported DB was 100+ MB and myphpadmin said it is too big to import...so I exported only the empty tables and filled the data with a special application.

 

[Erel]

Next time you can use mysqldump to create the backup and restore it with: http://stackoverflow.com/questions/...t-an-sql-file-using-the-command-line-in-mysql

 

[DonManfred]

Where are the database files located ?

see my.cnf (of mysql) for the path of the datafolder

 

[derez]

see my.cnf (of mysql) for the path of the datafolder

my.cnf was not found.
Found under xampp\mysql\data the directories with my DB, but when copied with another name phpmyadmin said the table is missing so I guess there is more data files somewhere else.
Restarted Xampp and mysql could not start ! had to remove the copied directory.
May be the best is to go the long way - install mysqldump like Erel suggested.

 

[DonManfred]

mysqldump is inside xampp\mysql\bin folder....

 

[derez]

mysqldump is inside xampp\mysql\bin folder....

When run (as administrator) it does nothing...

 

[DonManfred]

it is a cmd-line tool. What output you get?

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html

 

[derez]

it is a cmd-line tool. What output you get?

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html

Thanks, it works as command line. I'll learn the options when I'll have to move another DB...