Re: Include SQL files

On Wednesday 01 April 2009 16:49, Eugene Kosov wrote: > What about source? > > > use foobar; > > source some/dir/file1.sql; > source some/dir/file2.sql; > ... Gee... why did I not find that on google? :D Thanks... this give me control of the order of the files, which can be important. -- Jørn

Re: Mysql High load CPU

Tadeu Alves wrote: Thanks for this heads up i was thinking into some of these i was looking into the page that has the calculation of each looking into mysqlperformance blog it's a good idea of add more memory into this variables? query_cache_size= 1000M to 2000M and innodb_buffer_pool_siz

Re: Question!

On Tue, Mar 31, 2009 at 1:30 AM, Jarikre Efemena wrote: > Dear sir, > > I am young web developer using PHP Script in designing interactive website. > I desire to include Mysql database on my websites. > > Please, how do I import, upload/export Mysql database to a website server > after creating a

Re: how do I select multiple conditions from 1 table column?

David Giragosian wrote: > On Wed, Apr 1, 2009 at 1:27 PM, PJ > wrote: > > I am trying to select all books whose authors last names begin > with I, J > or K. I have 3 tables: book, author and book_author. The following > query > works with one con

Re: how do I select multiple conditions from 1 table column?

On Wed, Apr 1, 2009 at 1:27 PM, PJ wrote: > I am trying to select all books whose authors last names begin with I, J > or K. I have 3 tables: book, author and book_author. The following query > works with one condition but not with three. > SELECT * FROM book >WHERE id IN (SELECT bookID >

how do I select multiple conditions from 1 table column?

I am trying to select all books whose authors last names begin with I, J or K. I have 3 tables: book, author and book_author. The following query works with one condition but not with three. SELECT * FROM book WHERE id IN (SELECT bookID FROM book_author WHERE authID IN (SELECT autho

mysqldump failing to load data

Hi, MySQL v4.1.22 on Linux 2.6.18-6-686 I have a dump file generate with mysqldump created by a version 4.1.10 server. I want to import the dump file into a different server. When I run mysqldump --database mydb --debug < mydumpfile.sql I get the following: -- MySQL dump 10.9 -- -- Host: loca

Re: Total logged in time

Just a hint: Given the user 'User' and given no missing login/logout event logging you can retrieve the total amount in seconds he was logged on with the following formula: SELECT (SELECT SUM(time_to_sec(time_stamp)) as logoutTime from logevents where event='logout' and userid='User' ) - (SELE

ANN: MicroOLAP DAC for MySQL 2.7.1 released

Greetings! We are glad to announce DAC for MySQL version 2.7.1 (April 1, 2009) release. Version 2.7.1 is out. This release brings several optimizations and bugfixes since 2.7.0 release. Minor Design-Time errors fixed also. Don't forget to uninstall old version before installing the new one. If

Re: Include SQL files

What about source? use foobar; source some/dir/file1.sql; source some/dir/file2.sql; ... Though, your solution is much simplier. Michael Dykman wrote: No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jør

Re: Include SQL files

No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes wrote: > Hello, > > After googling for an hour I gave up to find a solution. > > Problem: A framework is creating a lot of SQL files that will c

Include SQL files

Hello, After googling for an hour I gave up to find a solution. Problem: A framework is creating a lot of SQL files that will create the database. But I'm tired of doing 10-20-30 'mysql -u... < file.sql' each time I rebuild the model. What I want to do is to create a sql file like: use foobar

Total logged in time

Hi, I have a table like so id autoinc userid int action enum ('login', 'logout' ) timestamp -- Is it possible to perform a mysql query that gets the total logged in time for any one user on any one particular day/week/month? And how? -- MySQL General Mailing List For list archives: http://lis

Re: Joining memory tables is very very slow!

> I'm using MySQL 5.1.30 and have several memory tables with indexes on the > appropriate columns. When I try and join 2 particular memory tables together > to get 5k rows, it takes 90 seconds. > This is incredibly slow considering table1 has 11k rows and table2 has 5k > rows. A table join like thi

Re: MySQL - facts

> Need some facts for a Report ... > For a hypothetical Kitchen Company's shopping Catalogue. >  a.. What advantages does a database have over flat-file systems ? great advantage when processing large amounts of data. >  b.. Are there any disadvantages in switching to a database solution ? databas

Re: Free "Database Workbench 3.3 Lite for MySQL" available!

> Hello everyone, > > Upscene Productions introduces the FREE "Lite Edition" of > Database Workbench for MySQL. > > More info: > http://www.upscene.com/displaynews.php?item=20090331 > and > http://www.upscene.com/products.dbw.index.php#lite > > This is a limited but useful version of "Database Work

Free "Database Workbench 3.3 Lite for MySQL" available!

Hello everyone, Upscene Productions introduces the FREE "Lite Edition" of Database Workbench for MySQL. More info: http://www.upscene.com/displaynews.php?item=20090331 and http://www.upscene.com/products.dbw.index.php#lite This is a limited but useful version of "Database Workbench Pro", availa