464 reputation
1316
bio website
location
age
visits member for 1 year, 1 month
seen May 7 at 17:44
stats profile views 41

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