There are some of backup scripts written by me.You can find it at:
http://blog.chinaunix.net/u/29134/article_71953.html
On Wed, Oct 22, 2008 at 4:52 PM, Mad Unix [EMAIL PROTECTED] wrote:
Any one tried the script from HowToForge
Just use another term will solve your problem.Or you can use pager more in
mysql command line client.
On Sun, Sep 28, 2008 at 12:44 AM, Dan Nelson [EMAIL PROTECTED]wrote:
In the last episode (Sep 27), Alex Katebi said:
Hi,
When selecting (example: select * from mysql.db ) some of the
Create an extra trigger on that table with delete event.Then the deleted
item will be recorded in the database.
On Fri, Oct 10, 2008 at 11:34 PM, Jerry Schwartz [EMAIL PROTECTED]
wrote:
Thanks.
Although I've been around SQL for quite a while, I've never really gotten
the hang of
Or you can create a temporary table including a auto_increment attribute and
fill it with continuous numbers.
Then simply use it to left join the original table.
On Sat, Oct 25, 2008 at 2:57 PM, Moon's Father [EMAIL PROTECTED]wrote:
Create an extra trigger on that table with delete event.Then
Hi all,
I had a server pretty much locked up this morning due to the mysql bin logs
filling up the /var filesystem.
I had been investigating the my.cnf settings file a white back, got
sidetracked, and never finished it.
The bin logs are named:
/var/db/mysql/myserver-bin.01
Joerg Bruehe wrote:
Hi Mark, all!
Mark Goodge wrote:
I'd appreciate some advice on how best to handle a biggish dataset
consisting of around 5 million lines. At the moment, I have a single
table consisting of four fields and one primary key:
partcode varchar(20)
region varchar(10)
location
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does
from the exact same remote machine, the exact same username, etc. There
is something about the wildcard ACL that is not working
Hi everybody,
last week some friends started to think about a viable solution to
implement a SssS infrastructure to develop our applications on and
give the final users the power to customize every aspect of the
application (objects, properties, relations, processes and workflows)
...
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty [EMAIL PROTECTED]
Deleting the files from the command line is not considered the 'correct' way:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
There should be a 'log-bin' line in your my.cnf just comment it if
you don't want binary logs. Yes, they're mostly just used for
master/slave
Fish Kungfu wrote:
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
Sure!
On what I'll call mynewserver
I think I see the typo. If that's an exact copy paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
I think I see the typo. If that's an exact copy paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
Hmmm, that is strange indeed. Hopefully one of the Level 70+ MySQL Wizards
on the list can explain why this might happen.
~~Fish~~
On Sat, Oct 25, 2008 at 4:44 PM, Joe Auty [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fish Kungfu wrote:
| I think I see the
14 matches
Mail list logo