Re: Administrative Tools
> Hello > > I am looking for the tools that I would use to be able to do administrative duties and to be able to create and update databases (tables, indexes and so forth). I would rather do this than do it via a command line. I would appreciate any links available. > If you're on Windows, you might take a look at Database Workbench - www.upscene.com Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Diff between restore from tar and recover from power outage
If mysql has been shut down, and given enough time for the tables to be flushed to disk, then backing up the data dir using tar is fine. You can tar the data dir without shutting down, providing all transactions have been stopped and the tables have been flushed to disk. This is how we backup our servers, and we haven't had an issue yet (restoring daily to a testing environment). Regards, Scott Tanner On Mon, 2007-06-04 at 14:57 -0700, Wm Mussatto wrote: > On Mon, June 4, 2007 14:21, murthy gandikota said: > > Hi > > When restoring a DB from a tar file, I had to repair some of the tables. > > Whereas when the DB is started after a power failure, everything works > > fine. I noticed this on RedHat linux and MySQL5. > > > > Any thoughts? > > > > Thanks > > Murthy > > > What was in the tar file? If you tar'ed the data directory, it is almost > guaranteed to fail since only part of the updated information may be > actually written to disk. If the power failure occurred on a system with > a correctly configured UPS, mysql probably got a shut down command so the > disk files were in a stable state. > > Normally you should dump the databases and then tar that. (see mysqldump > command for details). > > --- > > William R. Mussatto, Senior Systems Engineer > http://www.csz.com > Ph. 909-920-9154 ext. 27 > FAX. 909-608-7061 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Administrative Tools
I'm partial to SQLYog. http://www.webyog.com/ -- community and enterprise editions are available. Former is free, latter is cheap. Tim > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, June 04, 2007 2:17 PM > To: mysql@lists.mysql.com > Subject: Administrative Tools > > Hello > > I am looking for the tools that I would use to be able to do > administrative duties and to be able to create and update databases > (tables, indexes and so forth). I would rather do this than do it via a > command line. I would appreciate any links available. > > Andrew > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Magazine - Issue 1 available NOW!!!!
On Mon, Jun 04, 2007 at 02:44:25PM -0700, Daevid Vincent wrote:
> Thanks for the magazine. I already incorporated a little extra SQL
> injection checking into my db.inc.php wrapper...
>
> //[dv] added to remove all comments (which may help with SQL injections
> as well.
> $sql = preg_replace("/#.*?[\r\n]/s", '', $sql);
> $sql = preg_replace("/--.*?[\r\n]/s", '', $sql);
> $sql = preg_replace("@/\*(.*?)\*/@s", '', $sql);
Um, what? Both that and the methods described in the magazine are
completely wrong. You use mysql_real_ecape_string(), that's it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Magazine - Issue 1 available NOW!!!!
Well, they're PHP syntax to go along with the article about SQL
injection.
According to this page:
http://dev.mysql.com/doc/refman/5.0/en/comments.html
There are basically three styles of comments.
I just have a wrapper class for all my SQL queries (db.inc.php) and I
added a little cleaning code that strips out anything that looks like
comments. It could be argued that since they're comments already, mySQL
shouldn't parse them, but just to be safe.
The real issue to look for is the ";" (semicolon). I have another
routine that looks for ; and doesn't execute if it finds one outside of
" or ' mark pairs.
d
> -Original Message-
> From: Néstor [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 04, 2007 3:01 PM
> To: MySQL General
> Subject: Re: MySQL Magazine - Issue 1 available NOW
>
> Can you explain what each of those lines do?
>
> Thanks,
>
> Nestor
>
> PS
> Great work on the mysql article
>
> On 6/4/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> >
> > Thanks for the magazine. I already incorporated a little extra SQL
> > injection checking into my db.inc.php wrapper...
> >
> > //[dv] added to remove all comments (which may help with
> SQL injections
> > as well.
> > $sql = preg_replace("/#.*?[\r\n]/s", '', $sql);
> > $sql = preg_replace("/--.*?[\r\n]/s", '', $sql);
> > $sql = preg_replace("@/\*(.*?)\*/@s", '', $sql);
> >
> > Keep up the great work!
> >
> > d
> >
> > > -Original Message-
> > > From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, June 04, 2007 9:56 AM
> > > To: MySQL General
> > > Subject: MySQL Magazine - Issue 1 available NOW
> > >
> > > Everyone,
> > >
> > > I have just uploaded the first issue MySQL Magazine to
> > > http://paragon-cs.com/mag/issue1.pdf
> > >
> > > Please take a look at it. There is a great deal of
> > > information here and
> > > I think it is worth some time.
> > >
> > > Feedback is always welcome.
> > >
> > > thanks,
> > >
> > > Keith Murphy
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Magazine - Issue 1 available NOW!!!!
Can you explain what each of those lines do?
Thanks,
Nestor
PS
Great work on the mysql article
On 6/4/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
Thanks for the magazine. I already incorporated a little extra SQL
injection checking into my db.inc.php wrapper...
//[dv] added to remove all comments (which may help with SQL injections
as well.
$sql = preg_replace("/#.*?[\r\n]/s", '', $sql);
$sql = preg_replace("/--.*?[\r\n]/s", '', $sql);
$sql = preg_replace("@/\*(.*?)\*/@s", '', $sql);
Keep up the great work!
d
> -Original Message-
> From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 04, 2007 9:56 AM
> To: MySQL General
> Subject: MySQL Magazine - Issue 1 available NOW
>
> Everyone,
>
> I have just uploaded the first issue MySQL Magazine to
> http://paragon-cs.com/mag/issue1.pdf
>
> Please take a look at it. There is a great deal of
> information here and
> I think it is worth some time.
>
> Feedback is always welcome.
>
> thanks,
>
> Keith Murphy
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Diff between restore from tar and recover from power outage
On Mon, June 4, 2007 14:21, murthy gandikota said: > Hi > When restoring a DB from a tar file, I had to repair some of the tables. > Whereas when the DB is started after a power failure, everything works > fine. I noticed this on RedHat linux and MySQL5. > > Any thoughts? > > Thanks > Murthy > What was in the tar file? If you tar'ed the data directory, it is almost guaranteed to fail since only part of the updated information may be actually written to disk. If the power failure occurred on a system with a correctly configured UPS, mysql probably got a shut down command so the disk files were in a stable state. Normally you should dump the databases and then tar that. (see mysqldump command for details). --- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Magazine - Issue 1 available NOW!!!!
Thanks for the magazine. I already incorporated a little extra SQL
injection checking into my db.inc.php wrapper...
//[dv] added to remove all comments (which may help with SQL injections
as well.
$sql = preg_replace("/#.*?[\r\n]/s", '', $sql);
$sql = preg_replace("/--.*?[\r\n]/s", '', $sql);
$sql = preg_replace("@/\*(.*?)\*/@s", '', $sql);
Keep up the great work!
d
> -Original Message-
> From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 04, 2007 9:56 AM
> To: MySQL General
> Subject: MySQL Magazine - Issue 1 available NOW
>
> Everyone,
>
> I have just uploaded the first issue MySQL Magazine to
> http://paragon-cs.com/mag/issue1.pdf
>
> Please take a look at it. There is a great deal of
> information here and
> I think it is worth some time.
>
> Feedback is always welcome.
>
> thanks,
>
> Keith Murphy
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables Question
Once you issue a LOCK TABLES command, you may not access any tables not in the LOCK statement. You must lock *ALL* tables you will use, perform your updates, and then UNLOCK TABLES. I didn't know that. I reviewed the documentation. Thanks. OK, then my only remaining question is how many tables I can lock in a single SQL statement. I'm guessing no practical limit (i.e. thousands). What is the maximum length of a MySQL statement, anyway? Thanks.
Diff between restore from tar and recover from power outage
Hi When restoring a DB from a tar file, I had to repair some of the tables. Whereas when the DB is started after a power failure, everything works fine. I noticed this on RedHat linux and MySQL5. Any thoughts? Thanks Murthy - Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
Re: Lock Tables Question
David T. Ashley wrote: On 6/4/07, Jerry Schwartz <[EMAIL PROTECTED]> wrote: Whatever you do, make sure that every bit of code that locks multiple resources locks them in the same order. That's the only way to avoid deadlocks. Hi Jerry, I really appreciate the good advice. However, my original question is still unanswered. My original question is whether I can lock one table (as a gentleman's rule followed by all processes) to serialize access to the database consisting of many tables. LOCK TABLE x; Manipulate many tables, perhaps not even including table x; UNLOCK TABLES; My question is really whether MySQL might do some strange optimizations ... or somehow buffer the middle query so that it completes after the UNLOCK. Thanks, Dave. Once you issue a LOCK TABLES command, you may not access any tables not in the LOCK statement. You must lock *ALL* tables you will use, perform your updates, and then UNLOCK TABLES. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables Question
On 6/4/07, Jerry Schwartz <[EMAIL PROTECTED]> wrote: Whatever you do, make sure that every bit of code that locks multiple resources locks them in the same order. That's the only way to avoid deadlocks. Hi Jerry, I really appreciate the good advice. However, my original question is still unanswered. My original question is whether I can lock one table (as a gentleman's rule followed by all processes) to serialize access to the database consisting of many tables. LOCK TABLE x; Manipulate many tables, perhaps not even including table x; UNLOCK TABLES; My question is really whether MySQL might do some strange optimizations ... or somehow buffer the middle query so that it completes after the UNLOCK. Thanks, Dave.
RE: Lock Tables Question
Whatever you do, make sure that every bit of code that locks multiple resources locks them in the same order. That's the only way to avoid deadlocks. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: David T. Ashley [mailto:[EMAIL PROTECTED] > Sent: Monday, June 04, 2007 3:54 PM > To: mysql@lists.mysql.com > Subject: Re: Lock Tables Question > > On 6/4/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote: > > > > David T. Ashley wrote: > > >> > >> LOCK TABLE thistable, thattable, theothertable, > >> goshthislistcangetlongtable; > >> Do whatever is needed; > >> UNLOCK TABLES; > > >You could use a string lock for this. > > Thanks for the suggestion. It looks logically correct. > > I'd like to stay away from a string lock if possible because > other database > users could interfere with it (it is server global, and not > tied to the > database). > > My original question is still of interest to me ... > > Thanks. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables Question
On 6/4/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote: David T. Ashley wrote: LOCK TABLE thistable, thattable, theothertable, goshthislistcangetlongtable; Do whatever is needed; UNLOCK TABLES; You could use a string lock for this. Thanks for the suggestion. It looks logically correct. I'd like to stay away from a string lock if possible because other database users could interfere with it (it is server global, and not tied to the database). My original question is still of interest to me ... Thanks.
Re: Lock Tables Question
David T. Ashley wrote: I decided to go with a simple paradigm for my web-based database. Rather than transactions, each process locks the entire database while it is changing something, then unlocks it. This just serializes access (all other processes will block until the one modifying the database has finished). The method I was using is something like: LOCK TABLE thistable, thattable, theothertable, goshthislistcangetlongtable; Do whatever is needed; UNLOCK TABLES; I probably botched the syntax above. Rather than enumerate every table in the database (which could get to be a long list), I wondered if it is possible to just lock one table, with the gentleman's agreement that in order to modify the database, every process must first lock that particular table. You could use a string lock for this. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lock Tables Question
I decided to go with a simple paradigm for my web-based database. Rather than transactions, each process locks the entire database while it is changing something, then unlocks it. This just serializes access (all other processes will block until the one modifying the database has finished). The method I was using is something like: LOCK TABLE thistable, thattable, theothertable, goshthislistcangetlongtable; Do whatever is needed; UNLOCK TABLES; I probably botched the syntax above. Rather than enumerate every table in the database (which could get to be a long list), I wondered if it is possible to just lock one table, with the gentleman's agreement that in order to modify the database, every process must first lock that particular table. For example: #1)LOCK TABLE x; #2)Make modifications to tables x, y, and z; #3)UNLOCK TABLES; Are there any race conditions in just using one table for this purpose? For example, SQL guarantees that a given SQL statement is atomic. But it is guaranteed that #2 will complete before #3 above? If every process uses the same rule, can anything unexpected happen? One more note: I'm sure that many of the skilled users on this list will be tempted to advocate more sophisticated methods. I appreciate all advice, but I'm just looking for an easy way to serialize access to my database and guarantee mutual exclusion. Each operation I want to do would take at most half a second, so another web process waiting that long won't make a difference. Simpler is easier for me. Thanks.
Re: Documentation
At 12:16 PM -0700 6/4/07, <[EMAIL PROTECTED]> wrote: Hello I am going to be going on vacation and will be bringing my laptop with mysql installed on it. Is there a source of good documentation that can be downloaded (.doc or .pdf) for mysql? Downloadable document formats are available at the main documentation page on our web site: http://dev.mysql.com/doc/ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Documentation
You can download the MySQL manual from their website in PDF, ZIP, and HTML sources. http://dev.mysql.com/doc/index.html From: [EMAIL PROTECTED] Sent: Monday, June 04, 2007 3:17 PM To: mysql@lists.mysql.com Subject: Documentation Hello I am going to be going on vacation and will be bringing my laptop with mysql installed on it. Is there a source of good documentation that can be downloaded (.doc or .pdf) for mysql? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Documentation
Hello I am going to be going on vacation and will be bringing my laptop with mysql installed on it. Is there a source of good documentation that can be downloaded (.doc or .pdf) for mysql? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Issue with SubSelect Quey
Leelu, >The above Query's subselect query doesn't work properly, it lists >even the posts whose forum id is in subselect query. Your `post LEFT JOIN thread ON post.threadid=thread.threadid` asks for post rows whether they have matching thread rows or not. Are you sure you want that? It sounds backwards. Isn't your model like this... a forum may have threads, a thread may have posts ? Then wouldn't your query be... SELECT post.userid , post.pagetext , post.dateline , post.threadid, thread.title , thread.forumid FROM forum LEFT JOIN thread ON thread.forumid = forum.childlist LEFT JOIN post ON thread.threadid=post.threadid WHERE forum.userid <> xyz AND post.visible=1 AND thread.visible = 1 ORDER BY post.dateline DESC LIMIT 5; Or do I misunderstand your query? PB leeladharan acharya wrote: Hi, In MySQL, The following Query SELECT `post`.`userid` , `post`.`pagetext` , `post`.`dateline` ,`post`.`threadid` , `thread`.`title` , `thread`.`forumid` FROM `post`LEFT JOIN `thread` ON `post`.`threadid`=`thread`.`threadid` WHERE`userid`=`xyz` AND `thread`.forumid not in(SELECT `childlist` from`forum` where forumid=`xyz`) AND `post`.`visible`=1 AND`thread`.visible = 1 ORDER BY `post`.`dateline` DESC LIMIT 5; The above Query's subselect query doesn't work properly, it lists even the posts whose forum id is in subselect query. If the same Query with inner Query replaced by direct values gives the expected result set... Is this problem with My Query or Something else.. ? Regards Leelu No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.7/830 - Release Date: 6/3/2007 12:47 PM
re: Administrative Tools
MySQL GUI tools is one of the best out there, and it's specifically designed for MySQL. MySQL Administrator allows you to control the server. MySQL Query Browser lets you create and edit tables, indecies, etc MySQL Migration Tool helps you migrate from other popular RDBs to MySQL. http://dev.mysql.com/downloads HTH! From: [EMAIL PROTECTED] Sent: Monday, June 04, 2007 2:18 PM To: mysql@lists.mysql.com Subject: Administrative Tools Hello I am looking for the tools that I would use to be able to do administrative duties and to be able to create and update databases (tables, indexes and so forth). I would rather do this than do it via a command line. I would appreciate any links available. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Administrative Tools
Hello I am looking for the tools that I would use to be able to do administrative duties and to be able to create and update databases (tables, indexes and so forth). I would rather do this than do it via a command line. I would appreciate any links available. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What to Download
Hello I was trying to determine what to download to use mysql. I am going to use it for my own database server and also to write software that will incorporate mysql. I need assistance as to whether I should download the 5.0 version of mysql community server or the enterprise version. What is the difference between the 2 versions? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Issue with SubSelect Quey
Hi, In MySQL, The following Query SELECT `post`.`userid` , `post`.`pagetext` , `post`.`dateline` ,`post`.`threadid` , `thread`.`title` , `thread`.`forumid` FROM `post`LEFT JOIN `thread` ON `post`.`threadid`=`thread`.`threadid` WHERE`userid`=`xyz` AND `thread`.forumid not in(SELECT `childlist` from`forum` where forumid=`xyz`) AND `post`.`visible`=1 AND`thread`.visible = 1 ORDER BY `post`.`dateline` DESC LIMIT 5; The above Query's subselect query doesn't work properly, it lists even the posts whose forum id is in subselect query. If the same Query with inner Query replaced by direct values gives the expected result set... Is this problem with My Query or Something else.. ? Regards Leelu
Re: External Program Execution
> Not built-in. Try here: http://www.xcdsql.org/MySQL/UDF/index.html > > Cheers > Baron > Thanks Baron. This exactly what I want. Thank you. Actually I want to use this sys_exec in triggers and event scheduler (as Introduced in new version of MySQL server). by doing so I can completely replace cron-tab etc...? (as I think) I will test it soon. Nasir Iqbal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data migration Verification
On 6/4/07 12:31 PM, "paulizaz" <[EMAIL PROTECTED]> wrote: I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. Then I think you will also have to write a reverse migration script to convert all the data back into the old format. I suggest you do this to a different server than the original server. Then use mysql-table-checksum to verify you got exactly the same data back (http://sourceforge.net/projects/mysqltoolkit). I think this is your only option because you must compare the data to the authoritative copy of it, in the original format, if you want to make sure it is all correct in the new format. If you can convert both directions without loss, I think that is as strong a guarantee as you can get. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data migration Verification
I don't mean the whole thing. Pick some output that your applications usually produce and see if you can get the same results for both databases. I am not saying that this is the only and best way, just in addition to the mentioned sample approach. If you want to know for sure you will have to write an application that checks this for you, even if it runs for a while On 6/4/07 12:31 PM, "paulizaz" <[EMAIL PROTECTED]> wrote: > > What do you mean by "same output" ? > > I have too much data to go through and check if all the data is the same. > This is my problem. Sampling would speed this up, but I need something more > accurate. > All data is important. > > > > > Olaf Stein-2 wrote: >> >> Besides the sample approach, output data (a set you would output on a live >> system anyway) from both db setups and see if you can get the same output >> from both >> >> Olaf >> >> >> On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: >> >>> >>> Hi all, >>> >>> I have somebody creating a C# class to migrate data from one SQL database >>> to >>> another slightly differently structured SQL database. >>> >>> Please can anybody suggest ways to verrify that the data has migrated >>> successfully, in whole and acurrate?? >>> >>> I feel a sample approach would not quite be substancial. >>> I want to keep it seperate from the migration process itself (having my >>> person write a verification script may also not work as he will be using >>> the >>> same thought processes and knowledge that he used for the migration) >>> >>> Free Software, scripts, utilities, packages, industry approaches?? >>> >>> Sorry Im no Tech wizzard, Any ideas appreciated. >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Magazine - Issue 1 available NOW!!!!
Everyone, I have just uploaded the first issue MySQL Magazine to http://paragon-cs.com/mag/issue1.pdf Please take a look at it. There is a great deal of information here and I think it is worth some time. Feedback is always welcome. thanks, Keith Murphy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data migration Verification
On Mon, June 4, 2007 9:31, paulizaz said: > > What do you mean by "same output" ? Can you write a program to access both databases and have it check to see if the data matches. A lot depends on how the structure changed. If the new database rows have a one to one correspondence to the original database then 1st count the rows. If it passes that test compare the data in the new row with the corresponding data in the old row. Bill > I have too much data to go through and check if all the data is the same. > This is my problem. Sampling would speed this up, but I need something > more > accurate. > All data is important. > > > > > Olaf Stein-2 wrote: >> >> Besides the sample approach, output data (a set you would output on a >> live >> system anyway) from both db setups and see if you can get the same >> output >> from both >> >> Olaf >> >> >> On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: >> >>> >>> Hi all, >>> >>> I have somebody creating a C# class to migrate data from one SQL >>> database >>> to >>> another slightly differently structured SQL database. >>> >>> Please can anybody suggest ways to verrify that the data has migrated >>> successfully, in whole and acurrate?? >>> >>> I feel a sample approach would not quite be substancial. >>> I want to keep it seperate from the migration process itself (having my >>> person write a verification script may also not work as he will be >>> using >>> the >>> same thought processes and knowledge that he used for the migration) >>> >>> Free Software, scripts, utilities, packages, industry approaches?? >>> >>> Sorry Im no Tech wizzard, Any ideas appreciated. >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data migration Verification
What do you mean by "same output" ? I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. Olaf Stein-2 wrote: > > Besides the sample approach, output data (a set you would output on a live > system anyway) from both db setups and see if you can get the same output > from both > > Olaf > > > On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: > >> >> Hi all, >> >> I have somebody creating a C# class to migrate data from one SQL database >> to >> another slightly differently structured SQL database. >> >> Please can anybody suggest ways to verrify that the data has migrated >> successfully, in whole and acurrate?? >> >> I feel a sample approach would not quite be substancial. >> I want to keep it seperate from the migration process itself (having my >> person write a verification script may also not work as he will be using >> the >> same thought processes and knowledge that he used for the migration) >> >> Free Software, scripts, utilities, packages, industry approaches?? >> >> Sorry Im no Tech wizzard, Any ideas appreciated. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Data-migration-Verification-tf3852626.html#a10953205 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: External Program Execution
Nasir,
I am wondering if there is any way to execute external
application from MySQL procedures/trigger/event scheduler.
Like as we do in php with !,exec and system.
No, SQL isn't meant to be a complete computing language, and in any
event such capability would be a huge security headache.
PB
-
Nasir Iqbal wrote:
Hi,
I am wondering if there is any way to execute external application from
MySQL procedures/trigger/event scheduler. Like as we do in php with !,
exec and system.
I want to know that if there is any way(simple SQL command, pacth) to do
it. so I can execute external application like
???('php -d myScriptName.php')
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Would you like to explore Opportunity with Microsoft.......
Hi, This is with reference of your profile for regarding job opportunities with Microsoft IDC, Hyderabad. As you know Microsoft is on hiring spree and IDC is Microsoft's second biggest development center and is currently working on 35 products and technologies including Windows Vista, Visual Studio, Office Mobile, MS-CRM, MSN, Office Live Meeting and Windows Serviceability. IDC may be thousands of miles away from Redmond (US), but it's mission remains the same: To enable people and businesses throughout the world realize their full potential . Microsoft reached its 1000th landmark of total number of employees in June and still expanding on a rapid pace keeping itself focused on only quality resources and most evolved process of interview. Below is the link providing information on all the product units and the products being developed by them in IDC. http://www.microsoft.com/india/indiadev/default.aspx Please reply me back with your consent and updated profile so as we can initiate the process soon. The information passed on to us will be kept confidential. Also let me know, if you have been interviewed by Microsoft Earlier. If yes, please mention when. In case you have some queries then mail me back with your contact number and we can fix some time to discuss over phone. Regards, Shikha Saxena Recruitment Executive
Re: External Program Execution
Hi,
Nasir Iqbal wrote:
Hi,
I am wondering if there is any way to execute external application from
MySQL procedures/trigger/event scheduler. Like as we do in php with !,
exec and system.
I want to know that if there is any way(simple SQL command, pacth) to do
it. so I can execute external application like
???('php -d myScriptName.php')
Not built-in. Try here: http://www.xcdsql.org/MySQL/UDF/index.html
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stable mysql 4.xx
I might have misread the original message, but it sounded to me like the person was looking for earlier software than available via the official download links. I personally don't have any need for old versions, but I use Giuseppe Maxia's mysql_sandbox tool to run many different versions so I can test the tools I write (mysqltoolkit, innotop) against them. Mogens Melander wrote: I'm haing a hard time figuring out why you want an old 4.0 server, when newer better versions are available. MySQL 4.0.27 can be downloaded from Softpedia: http://linux.softpedia.com/progDownload/MySQL-Download-3074.html On Mon, June 4, 2007 00:44, Baron Schwartz wrote: Only back to 4.1.x -- before that, they say it's no longer supported. I couldn't find a way to get it, anyway. Mogens Melander wrote: If i'm not mistaken, the mysql site, also has older versions. On Sun, June 3, 2007 18:31, Baron Schwartz wrote: Hi, Subasta.pl - Darmowe Aukcje Internetowe wrote: Hello, Where I can find the best stable version 4.xx? Some of the mirrors still have older versions, such as http://mysql.mirrors.pair.com/ Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- Baron Schwartz http://www.xaprb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
