Hi All
My scenario is:
1. I've exported 1 row of the database to a CSV file using Export > Export Grid Data as CSV
2. the default export settings are
Fields Separated by ;
Fields enclosed by "
lines terminated by \r\n
3. I've attempted to import using Import > Import CSV file
4. The default import settings were used:
terminated by ;
eonclosed by "
escaped by "
However, the row in my destination db is not updated. No error is showing up in the output.
I've tried every combination I can think of but no joy. I assume I'm missing something simple.
Any suggestions??
Problems Importing with CSV
I have a follow up question: What I want to do now is to set up a scheduled task that will do copy over a query automatically. I've read up on EVENTS but can this work for accessing a remote MySQL db and send the data to another?
If can answer this anse, I'll buy you a beer :)
If can answer this anse, I'll buy you a beer :)
Yes I can answer but likely the answer won't make you happy so the beer might be lost :/
However, you can use events to schedule nearly any SQL command, and the scheduler runs on the server. That surely restricts events to the same workspace as SQL commands are restricted - the server it runs on. No remote stuff possible I'm afraid.
Without knowing what you're exactly trying to do, I think you can accomplish that using
- cronjob / Windows scheduled tasks
- a batch file which calls...
- mysql.exe
Just fetch data from one server and import it on the other host with a second call to mysql.exe
However, you can use events to schedule nearly any SQL command, and the scheduler runs on the server. That surely restricts events to the same workspace as SQL commands are restricted - the server it runs on. No remote stuff possible I'm afraid.
Without knowing what you're exactly trying to do, I think you can accomplish that using
- cronjob / Windows scheduled tasks
- a batch file which calls...
- mysql.exe
Just fetch data from one server and import it on the other host with a second call to mysql.exe
Please login to leave a reply, or register at first.