cPanel Forums - Database Discussions http://forums.cpanel.net/ Everything database-related including database users, MySQL®, PostgreSQL, phpMyAdmin and phpPgAdmin. en Wed, 22 May 2013 22:37:36 GMT vBulletin 1440 http://forums.cpanel.net/granite2/images/misc/rss.png cPanel Forums - Database Discussions http://forums.cpanel.net/ Percona http://forums.cpanel.net/f354/percona-347801.html Tue, 21 May 2013 19:24:35 GMT I am thinking installing Percona as a replacement for MySQL, mostly because i read that Percona (compared to MariaDB and MySQL) works better with InnoDB that xenForo is using... Installing Percona will it cause any issues if i later want to upgrade lets say my PHP, my cPanel, EasyApache or... I am thinking installing Percona as a replacement for MySQL, mostly because i read that Percona (compared to MariaDB and MySQL) works better with InnoDB that xenForo is using...


Installing Percona will it cause any issues if i later want to upgrade lets say my PHP, my cPanel, EasyApache or anything else?

Thanks in advance ]]> Database Discussions gmaister22 http://forums.cpanel.net/f354/percona-347801.html Download a MySQL Database Backup error special characters http://forums.cpanel.net/f354/download-mysql-database-backup-error-special-characters-347762.html Tue, 21 May 2013 17:09:56 GMT Backup -> Download a MySQL Database Backup *cPanel Version 11.38.0 (build 7)* from the date of 'May 8 onwards all dump extrapolated in this way show errors such as special characters instead of letters with accents....]]> Hi. I have a problem with the backup of the database operated by cPanel -> Backup -> Download a MySQL Database Backup
cPanel Version 11.38.0 (build 7)
from the date of 'May 8 onwards all dump extrapolated in this way show errors such as special characters instead of letters with accents.
example
à ÃÂ
é è
:mad::mad:
And so the backup is unusable. I think that the problem is a different encoding dump introduced in some updates from the date of May 8, in fact everything worked perfectly previously.

If I do a dump (export) of the same database from PhpMyAdmim everything works properly.

This anomaly occurs in all areas (different zones and database). ]]> Database Discussions 2cagency http://forums.cpanel.net/f354/download-mysql-database-backup-error-special-characters-347762.html Having formatting problems when exporting table from phpMyAdmin .. http://forums.cpanel.net/f354/having-formatting-problems-when-exporting-table-phpmyadmin-347442.html Sun, 19 May 2013 19:41:11 GMT I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.

The table I'm exporting has 2 columns in it:

Code:
Movie Name | Description
Movie Name contains a name, such as Argo. No problems in the movie name. The corresponding entry for Description contains this:

Code:
<h2>Product Details</h2>

<ul>
    <li><b>Actors:</b> Ben Affleck, Bryan Cranston, Alan Arkin, John Goodman</li>
    <li><b>Directors:</b> Ben Affleck</li>
    <li><b>Writers:</b> Chris Terrio</li>
    <li><b>Producers:</b> Ben Affleck, Grant Heslov, George Clooney, David Klawans, Nina Wolarsky</li>
    <li><b>Format:</b> AC-3, Blu-ray, Dolby, NTSC, Subtitled, Widescreen</li>
    <li><b>Language:</b> English, Spanish</li>
    <li><b>Subtitles:</b> Spanish, Portuguese, French</li>
    <li><b>Subtitles for the Hearing Impaired:</b> English</li>
    <li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
    <li><b>Aspect Ratio:</b> 2.40:1</li>
    <li><b>Number of discs:</b> 2</li>
    <li><b>Rated: </b> <span class=""medSprite s_medR ""><span>R (Restricted)</span></span></li>
    <li><b>Studio:</b> Warner Home Video</li>
    <li><b>DVD Release Date:</b> February 19, 2013</li>
    <li><b>Run Time:</b> 120 minutes</li>
</ul>
That is, the WHOLE HTML block above is the Description value for that Argo record.

But when I export the above from phpMyAdmin, this is what I see for the Movie Name & Description combined:

Code:
Argo;&lt;h2&gt;Product Details&lt;/h2&gt;                 

&lt;ul&gt;                 
    &lt;li&gt;&lt;b&gt;Actors:&lt;/b&gt; Ben Affleck    Bryan Cranston  Alan Arkin  John Goodman&lt;/li&gt;       
    &lt;li&gt;&lt;b&gt;Directors:&lt;/b&gt; Ben Affleck&lt;/li&gt;                 
    &lt;li&gt;&lt;b&gt;Writers:&lt;/b&gt; Chris Terrio&lt;/li&gt;                 
    &lt;li&gt;&lt;b&gt;Producers:&lt;/b&gt; Ben Affleck  Grant Heslov    George Clooney  David Klawans  Nina Wolarsky&lt;/li&gt; 
    &lt;li&gt;&lt;b&gt;Format:&lt;/b&gt; AC-3    Blu-ray    Dolby  NTSC    Subtitled  Widescreen&lt;/li&gt;
    &lt;li&gt;&lt;b&gt;Language:&lt;/b&gt; English  Spanish&lt;/li&gt;           
    &lt;li&gt;&lt;b&gt;Subtitles:&lt;/b&gt; Spanish  Portuguese  French&lt;/li&gt;         
    &lt;li&gt;&lt;b&gt;Subtitles for the Hearing Impaired:&lt;/b&gt; English&lt;/li&gt;               
    &lt;li&gt;&lt;b&gt;Region:&lt;/b&gt; Region A/1 (Read more about DVD/Blu-ray formats.)&lt;/li&gt;                 
    &lt;li&gt;&lt;b&gt;Aspect Ratio:&lt;/b&gt; 2.40:1&lt;/li&gt;                   
    &lt;li&gt;&lt;b&gt;Number of discs:&lt;/b&gt; 2&lt;/li&gt;                 
    &lt;li&gt;&lt;b&gt;Rated: &lt;/b&gt; &lt;span class=&quot;medSprite s_medR &quot;&gt;&lt;span&gt;R (Restricted)&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;                   
    &lt;li&gt;&lt;b&gt;Studio:&lt;/b&gt; Warner Home Video&lt;/li&gt;                 
    &lt;li&gt;&lt;b&gt;DVD Release Date:&lt;/b&gt; February 19  2013&lt;/li&gt;               
    &lt;li&gt;&lt;b&gt;Digital Copy Expiration Date:&lt;/b&gt; February 19  2015 (Click here for more information)&lt;/li&gt;             
    &lt;li&gt;&lt;b&gt;Run Time:&lt;/b&gt; 120 minutes&lt;/li&gt;                 
&lt;/ul&gt;
Secondly, the CSV file that I output from phpMyAdmin puts the individual lines from the above block into separate Excel rows and columns. This is not what I want.

How can I export data from phpMyAdmin such that the whole Description block appears in just ONE excel cell, next to the corresponding movie name ?

And also, if possible (although not required), have the Description shown in normal HTML tags (like in the top most code block shown in this thread) ?

This is what I want:

Code:
Argo | .....Complete Argo HTML here.....

Batman Begins | .....Complete Batman Begins HTML here.....

Flight | .....Complete Flight HTML here.....

Fight | .....Complete Fight HTML here.....
How can I export from phpMyAdmin so that the output is in the above mentioned format ? ]]> Database Discussions ahmadka http://forums.cpanel.net/f354/having-formatting-problems-when-exporting-table-phpmyadmin-347442.html Munin - mysql Restart http://forums.cpanel.net/f354/munin-mysql-restart-347301.html Sat, 18 May 2013 20:00:59 GMT Hello : I use munin for server monitoring , but every 5 min when munin update Mysql server restarted ! why this issue occurred ? Thanks Hello :

I use munin for server monitoring , but every 5 min when munin update Mysql server restarted !
why this issue occurred ?

Thanks ]]> Database Discussions mahdy_sharifi http://forums.cpanel.net/f354/munin-mysql-restart-347301.html Backing up a busy DB http://forums.cpanel.net/f354/backing-up-busy-db-346241.html Tue, 14 May 2013 10:37:50 GMT Hi, I have a very busy forum (phpBB) that I need to make sure is backed up properly. It was originally installed as MyISAM but I have had issues with the backups not being valid due to the file changing whilst it is in use. My question is, if I switch to using InnoDB will the WHM backup... Hi,

I have a very busy forum (phpBB) that I need to make sure is backed up properly. It was originally installed as MyISAM but I have had issues with the backups not being valid due to the file changing whilst it is in use.

My question is, if I switch to using InnoDB will the WHM backup routine take a hot copy or will I have to script that myself so I essentially have a backup within the site, that gets backed up (as a file) in the overnight routine?

I know taking a backup via the command line is a lot easier using innoDB, I just wondered if WHM was capable of doing similar?

If anyone could shed some light on this it'd be much appreciated, as I am a little nervous that my DB backups may be invalid if the data changes during the backup routine.

Thanks ]]> Database Discussions sp3ctre69 http://forums.cpanel.net/f354/backing-up-busy-db-346241.html PhpMyAdmin http://forums.cpanel.net/f354/phpmyadmin-346192.html Tue, 14 May 2013 08:33:28 GMT Hello, It is possible to give to my developer of my website direct access to phpMyAdmin without using the cPanel authentication . Thank you for helping me. Hello,

It is possible to give to my developer of my website direct access to phpMyAdmin without using the cPanel authentication .
Thank you for helping me. ]]> Database Discussions wafaa http://forums.cpanel.net/f354/phpmyadmin-346192.html Mysql frequently down with Event Scheduler: Loaded 0 events http://forums.cpanel.net/f354/mysql-frequently-down-event-scheduler-loaded-0-events-343481.html Tue, 07 May 2013 11:05:24 GMT One of our server mysql keep down frequently with the following errors.

130507 5:14:06 InnoDB: Started; log sequence number 119 391265068
130507 5:14:06 [Note] Event Scheduler: Loaded 0 event

Repaired all the database and configured values very well in my.cnf.

how to fix it? ]]> Database Discussions gopkris2005 http://forums.cpanel.net/f354/mysql-frequently-down-event-scheduler-loaded-0-events-343481.html cPanel Backup - Restore Database - Error 101 http://forums.cpanel.net/f354/cpanel-backup-restore-database-error-101-a-343301.html Mon, 06 May 2013 20:56:07 GMT Hey everyone,

Of course new to cPanel - Well Linux admin in general. Yes I have root, no I probably shouldn't. .

Anyway. Long story short, when I try to restore a MySQL backup file I get an error stating

"Error 101 (net::ERR_CONNECTION_RESET): The connection was reset." I am thinking it is something to do with my firewall config.

I had some troubles setting up a VNC and I messed with iptables and now a few things aren't working right lol.

Help? Thanks :D ]]> Database Discussions SmasheduP http://forums.cpanel.net/f354/cpanel-backup-restore-database-error-101-a-343301.html high process of mysql error log http://forums.cpanel.net/f354/high-process-mysql-error-log-343282.html Mon, 06 May 2013 19:37:37 GMT Hello

In my server's lists of processes there is always one that shows up and spends quite some cpu resources, this is the line in the process manager un WHM:

Quote:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/myserver.net.err --open-files-limit=6800 --pid-file=/var/lib/mysql/myserver.net.pid
I then trace it and this is what it shows:

Code:
Process 13333 attached - interrupt to quit
select(14, [12 13], NULL, NULL, NULL)  = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
accept(13, {sa_family=AF_FILE, path="\302Y\270k\352\22"...}, [8516025424675864578]) = 92
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(92, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876242
fcntl(92, F_SETFL, O_RDONLY)            = 0
fcntl(92, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(92, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(92, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)  = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
accept(13, {sa_family=AF_FILE, path="\302Y\270k\352\22"...}, [8516025424675864578]) = 92
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(92, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876242
fcntl(92, F_SETFL, O_RDONLY)            = 0
fcntl(92, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(92, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)  = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)          = 0
fcntl(489, F_GETFL)                    = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
select(14, [12 13], NULL, NULL, NULL)  = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)          = 0
fcntl(489, F_GETFL)                    = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
setsockopt(489, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
futex(0xdadba4, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xdadba0, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0xdacee0, FUTEX_WAKE_PRIVATE, 1)  = 1
select(14, [12 13], NULL, NULL, NULL)  = 1 (in [13])
fcntl(13, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
accept(13, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 489
fcntl(13, F_SETFL, O_RDWR)              = 0
getsockname(489, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
time(NULL)                              = 1367876415
fcntl(489, F_SETFL, O_RDONLY)          = 0
fcntl(489, F_GETFL)                    = 0x2 (flags O_RDWR)
fcntl(489, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
Some values change but its almost the same over and over.... the part that says (Operation not supported) is calling my attention, any idea on where should i look for to try to stop this. Thanks. ]]> Database Discussions madpato http://forums.cpanel.net/f354/high-process-mysql-error-log-343282.html One remote MySQL server for multiple CPanel servers http://forums.cpanel.net/f354/one-remote-mysql-server-multiple-cpanel-servers-342931.html Sat, 04 May 2013 21:26:39 GMT I have the same question on an old thread here

Quote:
Originally Posted by astopy View Post
Am I correct in thinking that I can't have multiple cPanel boxes all using the same remote MySQL installation? My understanding is that some databases with the same names (e.g. eximstats) would cause issues, and I'm guessing if I happened to have two users on different servers who had the same username then there might be issues with database ownerships since their database names would start with the same prefixes.

I'm intending to use one remote server with multiple MySQL instances bound to different IP addresses, one for each cPanel server. But obviously if it can be easily done with just one MySQL instance on the remote server then that might be better.
i've look into the database map tool but the mapping is to assign databases or database users to specific cpanel user, hence it's not mapping such as:

host1_eximstats
host1_horde
host2_eximstats
host2_horde
etc.

not to mention the problem if there are same usernames on both cpanel servers which will cause database ownership problem.

i've tried to setup a remote MySQL server and strangely the setup script failed to transfer eximstats database with message that it have to be transferred manually. there is also a test account database which is not transferred too, while databases such as horde and roundcube seems to be transferred correctly.

is this intended? that eximstats and databases created prior remote MySQL setup will remain in localhost?

and the database host information on CPanel is using IP address of the MySQL remote server, is it possible to show the hostname instead of IP address? this might be a problem if we have to move the MySQL server to a new/upgraded server hardware. ]]> Database Discussions markhard http://forums.cpanel.net/f354/one-remote-mysql-server-multiple-cpanel-servers-342931.html