Re: Database equivalent to NorthWind for M$ SQL
Peter Brawley [EMAIL PROTECTED] writes: Scott, Is there any database file similiar to M$'s Northwind that I can use to play with? It would be nice if there is one inside MySQL by default for newbies to start out with. For our chapters on Connector/ODBC and dotNet, Arthur I wrote scripts to create MySQL versions of the NW schema ... http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html (InnoDB) and http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html#11-2 (MyISAM). If you like, I'll email you the SQL script for populating the tables. PB I would like to see these scripts as well. Can you please post them somewhere, or mail them to me as well? Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Export OpenOffice XML to Mysql
Alvaro Cobo [EMAIL PROTECTED] writes: Hi guys: I have the following problem: In the organization I work for, we have several standard formats which we have to write for each project we manage (for example: reports). These are MS-Word documents, for which I have created a database and several forms to store this information. The problem is that it is very time consuming to insert manually each one of this documents. I think the solution is to create a OpenOffice Template for the document, with specific tags, to recover and export the file contents.xml (which is part of the *.sxw zip file) 'automagically' to the MySql database inserting each part of the XML to their specific field in the database. So the users only have to write the document, upload the file and the server does the job. The questions are: a) Is it possible to do that? Somebody has tried something like that?. b) What do you think about the idea? Could it be too complicated? Am I in the wrong path?. I will appreciate any clue or comment about these questions. I would go from the other direction. I would use OpenOffice.org to create a data entry template, where the user would enter the field information that goes into the database, then I would have an OpenOffice.org macro/template that would create the document out of the database fields. It seems conceptually easier to build the document from the data than to create the data from out of the document. Dave in Largo, FL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create an Innodb database ?
Danny Stolle [EMAIL PROTECTED] writes: So now also my question: When to use innodb instead of myisam? What performace advantages does this engine have? Well, if you want to have transactions, you must use innodb... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: starting MySQL
Darryl Reeves [EMAIL PROTECTED] writes: I am new to MySQL and was recently given a task where I need to transfer a database from one computer to another. Both computers are Macintoshes running OS X Panther. Both computers are running MySQL through localhost. The computer to which I am transferring the database has MySQL up and running perfectly fine. The computer from which I want to get the database is able to query the database through a web application using Perl but when I try to run MySQL from the Unix command line using the following text: mysql -h localhost -u root -p I get the following response -sh: mysql: command not found. As far as I know, MySQL is installed correctly on this machine (I would assume it has to be in order for the web application to access the database through Perl and MySQL). If I can start and run MySQL, I know that I can dump the database using the mysqldump command. Does anyone have any suggestions on what I need to do to get the mysql command to execute correctly so that I can run the program? You just need to find it first. As root, do find / -name mysql and see where it is hiding. Then either add that directory to your path, or use the full path in your command. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]