After backup/restore view turns to table

Hi All ! I did mysqldump mydb -uroot -ppass --databases --add-locks --allow-keywords --create-options --extended-insert --routines -r file.sql and after that in MySQL Command Line Client source file.sql After that my view was converted to an empty table. What should I do to backup and

Re: Backup: Copy MYSQL Directory or use MysqlDump

On 1/23/07, Alex Arul [EMAIL PROTECTED] wrote: Hi, MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM tables and copying them or shutting down the server and taring the entire MySQL directory if you are using innodb. If you are using innodb tables only you can run

Re: Backup: Copy MYSQL Directory or use MysqlDump

I used mysqlhotcopy and all is fine. Daniel da Veiga wrote: On 1/23/07, Alex Arul [EMAIL PROTECTED] wrote: Hi, MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM tables and copying them or shutting down the server and taring the entire MySQL directory if you are

RE: Ms access front end and mysql back end

If the connection itself passes a test, but MS Access hangs, I don't know what to suggest. I'm not an expert, it just worked when I tried it. You use File... Get external data... Link tables, right? Is that where it hangs? Does it list the tables in your MySQL data base, or doesn't it even get

New DBManager Released

Hi, DBTools Software is proud to announce the availability of the new DBManager Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2. For a complete list of changes please check our website at http://www.dbtools.com.br/EN. The new versions are available in our downloads

speeding up a join COUNT

I'm performance testing my 'users' table. It currently has roughly 1M user records. The 'geo_entities' table has ~ 250 records. Here's my query. SELECT users.entity_id, geo_entities.entity_name, geo_entities.short_code, COUNT( users.entity_id ) FROM users, geo_entities WHERE

Re: New DBManager Released

The free version is crippled. You don't get all the capabilities they say. COS [EMAIL PROTECTED] 1/23/07 8:16 AM Hi, DBTools Software is proud to announce the availability of the new DBManager Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2. For a complete list of

Unable to put data on a different computer from mysql

I've been trying to put the data onto our data drive, and the mysql application on the main server. I've edited the my.ini file correctly. I can get it to work on different drives where the data is on the same computer as mysql. I can't get it to work where the data is on a different

Re: Unable to put data on a different computer from mysql

On 1/23/07, Kelly Solakofski [EMAIL PROTECTED] wrote: I've been trying to put the data onto our data drive, and the mysql application on the main server. I've edited the my.ini file correctly. I can get it to work on different drives where the data is on the same computer as mysql. I can't get

Re: Unable to put data on a different computer from mysql

[EMAIL PROTECTED] (Kelly Solakofski) wrote in news:[EMAIL PROTECTED]: I've been trying to put the data onto our data drive, and the mysql application on the main server. I've edited the my.ini file correctly. I can get it to work on different drives where the data is on the same computer

Alias a function result?

I know that you can alias a function result as easily as anything else, but I've run into a problem with an application I inherited. For reasons too murky to go into, I would like to refer to the result of a group function as the name of the argument of the function. Here's an example of what I

Re: Alias a function result?

Jerry Schwartz wrote: I know that you can alias a function result as easily as anything else, but I've run into a problem with an application I inherited. For reasons too murky to go into, I would like to refer to the result of a group function as the name of the argument of the function. Here's