B4J Question Jrdc - where is the Database ?

derez

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

sorex

Expert
Licensed User
Longtime User
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.
 
Upvote 0

derez

Expert
Licensed User
Longtime User
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.
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
Upvote 0

derez

Expert
Licensed User
Longtime User
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.
 
Last edited:
Upvote 0
Top