> 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 m
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 ou
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: Ad
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("/#.*
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 cod
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
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
> Murth
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
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 tabl
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 we
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 ori
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 un
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
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.
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 da
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
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
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
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:
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
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.mys
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
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 t
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` fr
> 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
repla
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 mi
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 wr
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
F
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
da
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 y
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.
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
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 appl
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 c
34 matches
Mail list logo
