BY PASSWORD
> '*4EF5..6' |
> | GRANT SELECT, INSERT, UPDATE, DELETE ON `mydb`.* TO 'myuserid'@'%'
> |
>
> +---+
> 2 rows in set (0.00 sec)
>
> mys
gt;
>
> false
> false
> false
>
> EN-US
> X-NONE
> AR-SA
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
unsubscribe:http://lists.mysql.com/mysql
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
e in
> > central server.
> >
> >
> > How can we achive this ? solution needs very much real time data
> > accepting nework lags.
> >
> >
> > Solution
> >
> > Collect all changes in other 49 server into 1 central server(How can we
> > collect data)
> >
> >
> > 49 keeps updating data into local database from central server(Using
> > Repliation Can be done)
> >
> >
> >
> > --Anupam
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql To unsubscribe:
> > http://lists.mysql.com/mysql
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
: my.cnf information
> > >> # mysqlext_20120522131034.log : variable and status information from
> > >> mysqladmin
> > >>
> > >> I have 2 database working with high load.
> > >>
> > >> I wanted to speed up my s
mysqld# ls
> > root@devel:/var/run/mysqld#
>
> Is selinux enabled? If so, check the logs for that.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ou are notified that any dissemination, distribution or copying of this
> email is strictly prohibited. If you have received this email in error,
> please notify us immediately by return email or to
> mailad...@spanservices.com and destroy the original message. Opinions,
> conclusions and other information in this message that do not relate to the
> official business of SPAN, shall be understood to be neither given nor
> endorsed by SPAN.
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
>
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
>
> -- Dump completed on 2011-04-18 4:14:26
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
gt;
> Kay Rozeboom
> Information Technology Enterprise
> Iowa Department of Administrative Services
> Telephone: 515.281.6139 Fax: 515.281.6137
> Email: kay.rozeb...@iowa.gov
>
>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
; a better way to do live backups, or have a hot space in the event of a
> > > catastrophe? Is there 3rd party software that would better achieve
> data
> > > integrity or something?
> > >
> > > Any help here would be appreciated.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
o monitor the UPDATE/INSERT performance, check out if there's any
> performance bottleneck, for example:
> slow INSERT/UPDATE
> more I/O where execute INSERT
>
> Regards
>
> Thanks
> J.W
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.
top accessing some tables to open others.
>
> http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html
>
> --
>Dan Nelson
>dnel...@allantgroup.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To un
advise the sender immediately by
> e-mail
> or by telephone and then to delete this e-mail.
> Vox Orion accepts no liability for any loss, expense or damage
> arising from this e-mail and/or any attachments.
>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
file's at system level (using scp or rync) form slave machine to master
(after deleting ibdata1 and ib_log). update the variable innodb_file_per_table
to switch master to one per file table. and start master..
or I can go with usual process.. export and import.
And suggestion?
Best Regards,
Pr
com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?**
> unsub=aim.prab...@gmail.com<http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
which
> would have troubles?
>
> we have upgraded some hundret webspaces and two dbmail-servers
> in februray becaus we know our self written applications and
> having test-environments, if you can do this can nobody say
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ell> mv host_name.err-old backup-directory
>
> (Bug #29751)
>
> See also Bug #56821.
> "
> --
> Paul DuBois
> Oracle Corporation / MySQL Documentation Team
> Madison, Wisconsin, USA
> www.mysql.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
; notify us
> immediately at ad...@sifycorp.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
> Thanks.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
> >
> >
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql?**
> > unsub=sureshkumar...@gmail.com<
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com>
> >
> >
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
is
> generated
> > at time in two machines. (Logic is newest number will be displayed in the
> > node before admission).
> >
> > How can I stop this logical issue?
> > Can i have solution for this?
> >
> > Thank you in advance.
>
>
> --
> M
sql.com/mysql?**
> unsub=aim.prab...@gmail.com<http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
nition. Not kidding,
> here.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
e server? That can probably shed more
> light
> > on the issue...
> > --
> > Rik Wasmus
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=ave...@
to-increment in a lesser part of a primary key
> and InnoDB not--but although it is of interest, I have not tryed it.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsu
e practical implementation.
> >
> > Thanks & best Regards,
> > Adarsh Sharma
> >
>
> --
> Eric Bergen
> eric.ber...@gmail.com
> http://www.ebergen.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
nd
> of bugs is hiding somewhere in a forgotten corner of code, but given that
> we're running Drupal and Wordpress, I'd be surprised at something like that
> remaining unnoticed for so long.
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't
wrote:
> Hello,
>
> what system variables of mysqld can be changed on fly?
>
> thanks.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
-
; result successfully. What is the reason of the below error message :
> >
> > ERROR 2006 (HY000): MySQL server has gone away
> > No connection. Trying to reconnect...
> > Connection id:264550
> > Current database: *** NONE ***
> >
> >
> > Thanks in
where in i can go for Mysql Certification
> and
> mainly mysql replication set up material etc..
>
>
> --
> Thanks
> Pratiksha
>
>
> On Wed, Aug 11, 2010 at 5:39 PM, Prabhat Kumar wrote:
>
>> check this,
>>
>>
>> http://adminlinux.blogspot.com
> >
> > Show table status like 'tablename';
> >
> > Cheers,
> > Anirudh Sundar
> >
> > On Mon, Aug 9, 2010 at 9:31 PM, PRATIKSHA JAISWAL <
> > pratikshadjayswa...@gmail.com> wrote:
> >
> >> Hi All,
> >>
aster and slave which may or may
> not be critical.
>
> --
> William R. Mussatto
> Systems Engineer
> http://www.csz.com
> 909-920-9154
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
n are you to?
> >
> > What engines do you use (Innodb, MyISAM,etc)?
> >
> > Is the data directory currently mounted on a lvm volume?
> >
> > --
> > Rob Wultsch
> > wult...@gmail.com
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=sundar.anir...@gmail.com
> >
> >
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Mobile : 91-9987681929
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ards
> Karthik.P.R
> kart...@mafiree.com
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
; Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
t; For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
en all of
> the databases hosted there may become poorly organized resource hogs. If
> you, as a DBA, are diligent, protectful, proactive, and concerned then you
> will have a much better chance of achieving amazing performance out of your
> servers.
>
> Regards,
> --
> Shawn
; > there.
> >
> >
> >
> > All the queries are showing “sleep”
> >
> >
> >
> > Not sure if this means anything
> >
> >
> >
> > Machiel Richards
> >
> > MySQL DBA
> >
&
t; other way to resolve it ? And what's the exact reason behind this ? Just
> to
> > have mysql choose the correct index always will simply solve my problem .
> >
> > Thanks .
> >
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ur error log file.
> 2. Your my.cnf.
> 3. You servers specs and whether the server also runs other daemons.
>
>
> --
> Rob Wultsch
> wult...@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http
ctures, also, most users wont
>> have command access and its simple for them, it also doesn't require you
>> to install anything on your machine, I've tried a few in the past, but
>> none of them match up to phpmyadmin, and Marc (its author) is always
>> very approach
met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
örg
>
> --
> Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
> Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin
> Geschaeftsfuehrer: Juergen Kunz
> Amtsgericht Muenchen: HRB161028
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.
ma ;
> >
> >
> > Thank you.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
> >
> >
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
gt;
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.co
te list of variable. :
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
Thanks,
On Mon, May 31, 2010 at 3:17 PM, Lin Chun wrote:
> hi
>
> as the title
>
> thanks
>
> --
> ---------
> Lin Chun
>
--
Best Regards,
Prabhat Kumar
M
http://lists.mysql.com/mysql
>To unsubscribe:
> http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
>
>
>
>
>
> --
> John Daisley
>
> Certified MySQL 5 Database Administrator
> Certified MySQL 5 Developer
> Cognos BI De
tabase.
>
> However, that's not really an array datatype in MySQL, it's simply a method
> of storing an array as a string. So it's of fairly limited application,
> there are cases where it's very useful but it's not a substitute for storing
> the array values
t;
> >
> > Thanks,
> >
> > Jesse
> >
> >
> >
> > !DSPAM:451,4bed85fe818443309765824!
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub...@msdlg.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
sn't because there is nothing in the script to handle a 'stop' call; the
> actual question would be - why it doesn't work when it is mentioned in the
> MySQL reference manual?
>2. how to (auto) restart the instances after a server restart? do I
> need to wr
Thanks, It worked :)
On Mon, May 10, 2010 at 6:25 PM, Jay Ess wrote:
> On 2010-05-09 13:29, Prabhat Kumar wrote:
>
>> INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time,
>> username, datestamp) VALUES (NULL,'Kumar', '20&#
;You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
I think problem with* `datestamp` datetime NOT NULL default '0000-00-00
00:00:00',*
Can any one please suggest me, how to deal with this error.
--
Best
or you can use some tools, there is tons of third tools you can use.
On Sat, May 8, 2010 at 7:15 PM, Prabhat Kumar wrote:
> Hi,
> I think you can get only no. of transactions happned on the database since
> it was started.
>
> By using command "show status" ; varia
f=`expr $last - $orig`
> avg=`expr $diff / $time`
> echo "$avg"
>
Thanks,
On Sat, May 8, 2010 at 6:40 PM, Anand wrote:
> Hi ,
>
> Is it possible to find the no.of transactions happened on the database for
> the specified duration of time ? it could be for past
w can block update column of specif table for a user
> "x" by trigger in mysql?
> Is possible deny acess for columns on mysql?
>
>
> version: 5.0.77
>
> Regards
>
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-99
ed 's/.*\(SELECT.*\)/\1/gI' | sort | uniq -c | sort -r
> -n -k 1,1 | head -5
>
> Other question is. What commnds do you use to help debuging and testing.
>
> Kind Regards
> Brent Clark
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.
Wultsch
> wult...@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
ors-r-us.net/doc/refman/5.1/en/purge-master-logs.html
>
>
> --
> Rob Wultsch
> wult...@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar wrote:
> use can use mysqldump with option *-no-data
gt; Office: Blountville, TN
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
er after creating
> it?
>
> Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India M
this is handphone +65 84300135
>
> --
> Best Regards,
> Mubeeth
> S'pore +65-84300135
> India +91-99940 44101
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
min ago
> e.g over 1 day 1d 2h 29min ago
> e.g over 1 week 1w 4d 2h 29min ago
>
> How would this best be achieve using MySQL.
>
> Thanks,
> Neil
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blo
; >On Sat, Feb 6, 2010 at 12:33 PM, Vikram A wrote:
> >
> >> Dear Experts,
> >>
> >> I would like to configure the slave for my main server. My server is
> >> running in the FEDORA 11.
> >> I would like to make another mirror of the DB in the same server
T_NAME =
> 'PRIMARY';+-+| COLUMN_NAME |+-+| GameLogID |
> +-+1 row in set (0.00 sec)
> where it is assumed the database name is "game".
> Hope that helps.
> Jesper
> _
thousands) of symlinks
frequently and performs very little actual access work (small files), then
there will be a potential significant overhead.
On Fri, Jan 29, 2010 at 12:20 PM, prabhat kumar wrote:
> I don't agree, Don't have any specific documents but seems to make a bit
>
ere will be quite a few folders
> and
> > symlinks on the same path?
> >
> >
> > Thanks in advance.
> >
> >
> > --
> > Regards,
> > Manasi Save
> >
> >
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
.
On Fri, Jan 29, 2010 at 8:42 AM, Lucky Wijaya wrote:
> Hi all,
>
> I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I
> want to know if there's a way to change MySQL default database directory
> from C: to D:.
>
> Thanks.
>
>
>
>
seems that the decode function does not exist in mysql.
>
>
>
> select
>
> decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,
>
> count(*) tot
>
> from profiles
>
> where email is not null
>
> group by
umentation it says,
> RENAME DATABASE command has been removed from mysql 5.1.
>
>
> Can anyone help me with this, that is there any other way I can rename it.
>
>
> Thanks in advance.
>
>
> --
>
> Regards,
> Manasi Save
>
>
--
Best Regards,
Prabhat K
you want a compund PK on this new table, or you want
> > instead an auto-increment column that would be the PK. (There are
> > differences of opinion on this one, so I'm leaving it alone; I don't want
> to
> > start a religious war :)
> >
>
> Thanks! That
l adm1114 2009-12-15 16:26 mysql-slow.log.7.gz
>>
>> Which freed up a tremendous amount of space again...
>>
>> However, a co-worker informed me that now our slaves are broken and
>> replication is hosed!
>> What did I do wrong or forget to do?
>> I see no
Thanks Joerg. You are very correct.
On Thu, Oct 1, 2009 at 2:40 PM, Joerg Bruehe wrote:
> Hi!
>
>
> prabhat kumar wrote:
> > You can use :
> >
> > *ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
> >
> > it will add new column af
te:
>>>
>>>> hi Kumar
>>>>
>>>> thanks for your info..
>>>>
>>>> another doubt.. which storage engine is best for transaction..
>>>>
>>>> in my server. the default engine is myisam. now i changed one
#x27;test'@'%';
> *
>
> I used 'USAGE' clause this time but even after that i can able to see other
> schema and i can able to 'select' tables from other schema.
>
> how i can restrict this. only default schema should be accessible to the
> use
location. how to create
> that? because current mountpoint space is very less, in this situation how
> can move existing schemas to new location?
>
> thanks in advance..
>
>
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
&
Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database 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/mysql?unsub=aim.prab...@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
re the privileges are
> required..
>
> please help..
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
> On Thu, Oct 1, 2009 at 11:09 AM, prabhat kumar wrote:
>
>> Use : mysql -u root -p (it will prompt for password
Access denied for user 'root'@'localhost' (using
> password: NO)
>
>
> Can someone please help me understand why I am not able to login from root?
>
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
--
Best
gt; Thanks
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com
> >
> >
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
Step # 1 : Stop mysql service
# /etc/init.d/mysql stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Step # 4: Setup new MySQL root user password
mysql> use mysql;
mysql> update user set pas
84 matches
Mail list logo
