Hi, MySQL newbie question

[x508]

Hi

I'm very new to MySQL and would like to get some help on the following:

I imported all my records from access to MySQL

Now...everything seems fine, data went in well..but

MySQL stores my dates as 2004-02-11, where access stored them as 2004/02/11 (Which is my system format).

With this most of my reports don't function any more, cause they look for "Like 2004/02%"

Question #2

How secure is MySQL

I see that the database get stored in mysql\data\database name

When I want to backup the data, can I copy that folder...if so, will anybody that has access to this folder(data) be able to use it in their SQL server, or will the data be encrypted with the username and password that created them?

Tnanks in advance

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)

 

[sleipnir214]

I'm going to have to guess what exactly your first question is -- you didn't explicitly state it.

If your first question was, "Why doesn't MySQL output dates to match my system's date format settings?", then the answer is because MySQL's authors' design rationale is that MySQL should handle data, not data-formatting and prettying.

MySQL is platform-agnostic, meaning that unlike Access, it runs on a plethora of operating systems. Just look at the MySQL download page and you'll see that MySQL AB provides binary distributions for 14 OSes and architectures. Keeping track of how all those different OSes delineate system-wide format settings is difficult if not impossible -- some of those OSes may not have system-wide format settings.


Q2: The data in MySQL's data store is not encrypted. The rationale is that you should be locking users out of MySQL's data store files by filesystem permissions.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[x508]

Thanks Tansraafl

Another question:

My mYsql DB IS EXTREMELY SLOW, access open 4000 records in a datagrid in spilt second, MySQL takes 20 seconds for precisely the same data??

Imported data from access to MySQL

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)

 

[QatQat]

There could be a number of reasons.

Let's start from your platform.

Which one are you using? It looks like you are using windoz
Did you leave the table structure untouched after importing it? Are your text fields all very long?
Have you got a primary key defined? What do you mean by datagrid? Are you using ASP.NET datagrid object?

Please be more specific.


Bye

Qatqat

Life is what happens when you are making other plans.

 

[x508]

OS -> XP
Structure -> Left as imported
Text Fields -> Varchar(50)
Primrary Key -> The access Tables had Prim Keys, so I suppose it would have imported them, but just in case, I also specified the column which was primrary key in access, as primrary key in MySQL

Datagrid -> Visual Basic 6 Datagrid Object (Set DG1.Recordsource = rs (recordset object)


P.S. I cannot use the datagrid if I use a ServerSide Cursor for the connection, cause .RecordCount returns 0
(However everything is fast and up to speed when I manipulate data etc.)

When I use a client side cursor, the .RecordCount reports the right amount of records, but it takes about 20 seconds to open the recordset


Any help will be greatly appreciated

**********************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)

 

[QatQat]

RS recordcount does not work correctly with MySQL.

There is alot of literature about it on teh Internet.

here is a good page from MySQL.com

http://www.mysql.com/doc/en/MyODBC_clients.html

Bye

Qatqat

Life is what happens when you are making other plans.