Hi :) That is a good question.
Ultimately the Tables 'should' be in MySql (or whichever back-end you are using). One thing i don't know is if you can use the nice GUI front-end in Base to create the Tables and find the Tables are automatically in the external back-end. If it does work that way then it greatly reduces complexity by hiding the complexity away from the Database Designer. Ian, Alex, Dan, anyone any idea? Regards from Tom :) >________________________________ > From: rounak jain <[email protected]> >To: Dan Lewis <[email protected]> >Cc: "[email protected]" <[email protected]> >Sent: Sunday, 12 May 2013, 6:24 >Subject: Re: [libreoffice-users] help with database > > >[quote]What version of MySQL are you using?[/quote] >$ which mysql >/usr/local/mysql-5.6.11-osx10.7-x86_64/bin/mysql >[quote] Tables and their data are kept within >MySQL.........................After creating the schema, you can use Base >to create the tables for the schema.[/quote] >Confusing.....tables are to be created in MySQL or BASE? > > > >On Sun, May 12, 2013 at 9:50 AM, Dan Lewis <[email protected]> wrote: > >> On 05/11/2013 11:21 PM, rounak jain wrote: >> >>> I have connected my Base to MySql. Can you please clarify which tasks must >>> I perform in Base and which ones in MySql..............for example....I >>> guess I must create tables in MySql.......what about "Forms" and >>> "Queries"? >>> Where must I make the data entry? Sorry.....total newbie!!(and >>> intermediate Filemaker user) >>> >>> What version of MySQL are you using? The answer to this determines >> what you should do and how. >> Tables and their data are kept within MySQL. Forms, queries, views, >> and reports are created within the Base file you use to connect to MySQL. >> Databases and schema must be created within MySQL. How this is done >> depends upon the answer to my first question. A database must be created >> first. Then the schema for the database are created second. After creating >> the schema, you can use Base to create the tables for the schema. >> You have probably heard the advice RTM (read the manual). Well, you >> need to get a manual for the version of MySQL that you are using. >> I use MySQL 5.5 and the program, Workbench, is what I use for all >> administrative tasks for MySQL. When I used MySQL 5.1, I used mysqladmin to >> do these things. >> >> --Dan >> > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
