VFP Create and Register DB in MySQL
Posted on 2012-09-08
Here is what I am trying to do...
Using VFP 9 I want to create a db in MySQL and then register it.
Here's what I've done...
Created the db, created all table definitions and populated them with sample data.
Then I created two mysql dumps,
1) the first dump simply creates the database, and
2) the second dump contains all the tables and sample data.
Then for testing purposes I deleted the database and unregistered it from MySQL.
Now, to recreate the database...
I can execute (1) from within VFP and it does create the db. That's no problem.
However, without the db being 'registered' with mysql, I can't execute (2) that actually creates the tables and populates them.
If it matters, the MySQL db is running locally under XAMPP on Windows XP.