| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | May 7 at 17:44 | |
| stats | profile views | 41 |
Twitter:
|
Jul 16 |
comment |
How to Create Snapshot Backups in MySQL @AaronBrown thanks a lot for your comment, I did this question just to learn and not because I've a issue. My environment is Mysql 5.2, localhost, MAC, Thanks |
|
Jul 10 |
comment |
How to restore mysql from only myi files? I don't think that it's possible only with myi files, because they are more the structure(index) of the table than the data, I'm going to try yo put this question en DBA.stackoverflow |
|
Jul 10 |
comment |
How to restore mysql from only myi files? The MYI is only for MyISAM tables, what about the InnoDB or other engines?, take a look to this post: stackoverflow.com/questions/879176/… good luck |
|
Jul 5 |
comment |
Which mysql storage engine to choose? that's up to you, depending for what will you use the table, and if you are using mysql V-5.6+ you can create text index in Innodb Engines |
|
Jul 5 |
comment |
Which mysql storage engine to choose? the Aria Engine is getting close to use Transaction, so why don't use Aria instead? |
|
May 18 |
comment |
Does this cause overhead ? Select name from User where user_name LIKE '%alex%' @AaronBertrand yeap that's what I mean, about the (2) thanks, I'm agree with you, but I'm going to put a question about what I think hope you can answer it. |
|
May 18 |
comment |
Which is faster, InnoDB or MyISAM? Thanks a lot, I'll take a look |
|
May 17 |
comment |
is it possible to create a form in the intranet that can be stored in a database? I cannot tell you too much about Access as programming languages, but for that kind of simpler stuff I preffer php, or ROR for development, that's my personal opinion, would be great if some DAP programmer share something with us. |
|
May 17 |
comment |
Why shouldn't we allow NULLs? @AaronBertrand haha thanks, I asked you because I wanted to be 100% about the nulls fields ;) |
|
May 17 |
comment |
Why shouldn't we allow NULLs? @AaronBertrand no, I'm asking you the other way. Use null values because they are faster to checking. |
|
May 17 |
comment |
Why shouldn't we allow NULLs? @AaronBertrand is it not faster a query against null than 0, or any other vaue? |
|
May 17 |
comment |
How to select/count rows where the same value exists in a column but not in other column all at the same table @RolandoMySQLDBA boooo, you did it faster than me! hehe good one +1 |
|
May 17 |
comment |
How to Create Snapshot Backups in MySQL Did you see the new online method of Mysql 6 where you can make snapshots? is that better than this one I posted? |
|
May 17 |
comment |
converting mysql columns to bits in a single column can you explain better? I don't get your problem |
|
May 17 |
comment |
Copy complete structure of a table in MySQL without using a backup? @RolandoMySQLDBA the oracle question and answer are here dba.stackexchange.com/questions/18058/… the sql server are here=> dba.stackexchange.com/questions/18059/… |
|
May 17 |
comment |
Copy complete structure of a table in MySQL without using a backup? yes, I know, I would love to those ppl answer again the same answer to give them the point. that's why I separate the question because it wasn't fair give it the "check mark" only to one of them |
|
May 17 |
comment |
Copy complete structure of a table in MySQL without using a backup? @RolandoMySQLDBA it's ok, please vote to close the other one |
|
May 17 |
comment |
Copy complete structure of a table in MySQL without using a backup? @RolandoMySQLDBA please read the comments of the other post |
|
May 17 |
comment |
InnoDB possible error if you have PK, what is the var type? |
|
May 17 |
comment |
Copy complete structure of a table I think the primary option would be manually, but if it's not possible I'll accept any solution |