How to Restore MySQL Database from VB?

Hi all, I wish to restore an sql file in a mysql database though VB. One way of doing it is writing the Create Database command and the mysql restore command 'mysql -options < sql_file' in a batch file and executing it. Is there any other better way of doing it? Btw, I try to make an ADO connect

Re: MySQL Tables Load Slowly

--On Sunday, June 13, 2004 12:56 -0700 David Blomstrom <[EMAIL PROTECTED]> wrote: Aha! I added "EXPLAIN," like this... Please read the docs. And use the mysql CLI/monitor tool. Explain does just that, it EXPLAINs to you, the database programmer, what the MySQL engine will do when it goes about

How secure is your MySql

http://www.oxid.it/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can I make empty MySQL use less disk space?

Ahhh wait my bad, I misread your question The distribution includes benchmarks, examples, and a handful of documentation that can all be excluded. You can also use embedded mysql (IE mysql as a DLL sort of). --On Sunday, June 13, 2004 20:48 +0200 Martin Olsson <[EMAIL PROTECTED]> wrote: H

Re: Can I make empty MySQL use less disk space?

OPTIMIZE TABLE table; --On Sunday, June 13, 2004 20:48 +0200 Martin Olsson <[EMAIL PROTECTED]> wrote: Hi, I just noticed that the MySQL (win32) program which empty databases take up about 70Mb on my harddrive. I'm deploying MySQL as a part of a greater application (which is much smaller), is the

Re: MySQL Tables Load Slowly

INDEXes grasshopper, INDEXes. --On Sunday, June 13, 2004 11:26 -0700 David Blomstrom <[EMAIL PROTECTED]> wrote: I have a MySQL table with about 3,500 rows and 30 columns. There are rows for each of the world's nations, each of the 50 states, some 3,000 U.S. counties, Canada's provinces, etc. Obv

Re: Rank beginnner - very basic question

Briefly: GRANT ALL PRIVILEGES ON dbname.* TO user IDENTIFIED BY 'userspass'; CREATE DATABASE dbname; \q mysql -u user -p dbname Password: userspass mysql> NEVER *EVER* run ANYTHING using root. That's an administrative only user. Some applications may

Rank beginnner - very basic question

I have zero experience, really, with Mysql although I compiled it on a Linux box and it works well for a couple of sites and messageboards that I host from my house. I do this strictly for fun and would like to let some friends and family members have websites as well. Here's what I don't ge

Re: Connecting MySQL in Panther

chueewowee wrote: >[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with >databases from /usr/local/mysql/data >040612 23:32:05 mysqld ended mysqld isn't starting. See what the error log says, it will likely be in /usr/local/mysql/data --Ware -- MySQL General Mailing List For l

Re: MySQL Tables Load Slowly

--- Emmett Bishop <[EMAIL PROTECTED]> wrote: > David, > > It sounds like you need some indexes on your table. > Do > this... put the word EXPLAIN in front of the select > statement to you use to get your data. For more > info, > check out this link > http://dev.mysql.com/doc/mysql/en/EXPLAIN.html

Can I make empty MySQL use less disk space?

Hi, I just noticed that the MySQL (win32) program which empty databases take up about 70Mb on my harddrive. I'm deploying MySQL as a part of a greater application (which is much smaller), is there any way I can reduce this size somewhat? I mean like, the "examples", directory isnt really neces

MySQL Tables Load Slowly

I have a MySQL table with about 3,500 rows and 30 columns. There are rows for each of the world's nations, each of the 50 states, some 3,000 U.S. counties, Canada's provinces, etc. Obviously, I can't display the entire table on a web page. But even when I do an operation that displays just a sing

Re: load data question

Thanks Michael - I was being a putz wasn't I! You have a file of SQL statements. LOAD DATA INFILE is for importing a file of data (comma-separated, for example), not for reading a SQL file. You can do this from the command line with mysql name_of_db or within the mysql client program with

Re: load data question

You have a file of SQL statements. LOAD DATA INFILE is for importing a file of data (comma-separated, for example), not for reading a SQL file. You can do this from the command line with mysql name_of_db or within the mysql client program with source '/tmp/updates.txt'; Michael J S wrote:

load data question

Hi, I'm trying to load a file containing a set of updates e.g. UPDATE url_table SET hits=3 WHERE url="http://cache.unicast.com/java60/HTMLad_utils/ad2applet.js";; UPDATE url_table SET hits=2 WHERE url="http://abclocal.go.com/images/wabc/2003/wabc_images_whatsonseven.gif";; UPDATE url_table SET hi

Re: [OT] License question.

On Sun, 13 Jun 2004 12:43 , Santino <[EMAIL PROTECTED]> sent: >Hello, > >I sent a message to sales in order to have more info about licenses >but I have not received any reply, so I post to the list hoping >someone has any experience on it. > >A customer asks me to develop a Web-Application (I

[OT] License question.

Hello, I sent a message to sales in order to have more info about licenses but I have not received any reply, so I post to the list hoping someone has any experience on it. A customer asks me to develop a Web-Application (Intranet) tobrowse their photos and PDFs, so I'm going to prepare, with a