This is exactly what I am working on, more for importing a foreign database
that backing up, but it could be used for both. Unfortunately I am in the early
alpha stages, so I don't have much to offer you, except that I have a card
where you enter the connection information for 2 databases,
A schema dump is built in to MySQL:
assuming you are connected to the database, use this mysql call
desc tablename;
a data dump would need to be accomplished by scripting.
On 31 May 2010 11:35, JosepM jmye...@mac.com wrote:
Hi Folks,
I need to create and backup mySQL database from Rev. I
Hi,
I try this but no result.
mysqldump --opt myDB backupDB.sql
Sorry but I don't see how to dump the data by scripting.
Salut,
Josep
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237895.html
Sent
I try this but no result.
mysqldump --opt myDB backupDB.sql
I have used a shell call to the mysqldump command and that worked fine.
Cheers,
Sarah
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe,
message @
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237903.html
To unsubscribe from Re: Create mySQL database structure from Rev,
click here.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL
-tp2237715p2237903.html
To unsubscribe from Re: Create mySQL database structure from Rev,
click here.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237904.html
Sent from the Revolution - User mailing list archive
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
View message @
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237903.html
To unsubscribe from Re: Create mySQL database structure from Rev,
click here
If one just needs the schema try this command:
*show create table*
after opening the database
this will return data like this
2004_INV CREATE TABLE `2004_INV` (
`ID` int(11) NOT NULL,
`DATE_CREATE` date NOT NULL,
`DATE_CHANGE` date NOT NULL,
`BRIEF_DESC` varchar(255) NOT NULL,