You import a table via the green screen using the SOURCE command via the MySQL Monitor. Check out the IBM redbook page 182.
http://www.redbooks.ibm.com/abstracts/sg247398.html
Regards,
Mike
Office Phone: (708)233-5880 Cell: (408)679-1011
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Jeffrey Day
Sent: Thursday, September 27, 2012 1:35 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] phpMyAdmin - error 2002 - Server not responding
Hi,
Thank you Jim and Jack for responding.
Yes you are right, the daemon was ending - with end code 0, as mentioned below.
In previous posts, by both Jack and Mike P (thanks!), instructions for removing MySQL were given. I have followed them. Now the next step is a message and all is back working. I do get a bad message from phpMyAdmin, though, "Your PHP MySQL library version 5.0.45 differs from your MySQL server version 5.1.59. This may cause unpredictable behavior.". But I will figure this later.
Next step is to figure out how to import a table via green screen to avoid phpMyAdmin...
Thanks again for your help!
Jeff
From: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx> To:Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Date: 9/27/2012 1:22 PM
Subject: Re: [WEB400] phpMyAdmin - error 2002 - Server not responding IIRC MySQL connects on port 3306. Is there a MySQL listener running?
(netstat to find out). If not it sounds like the deamon is not running correctly.
If it is try the /pathtoyourinstance/MySQLadmin -u root password 'new-password' to reset the root password.
You might want to try to use: /pathtoyourserverinstance/MySQLd_safe & to start the MySQL deamon in safe mode
(all commands issued inside QSH)
I think the time to update to the DBi is a good idea anyway since is is the version that will get support if you have a contract with Zend/IBM.
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects
On 9/27/2012 12:13 PM, Jack Kingsley wrote:
jeff, if you pan through this site your error is described in here:
http://www.itjungle.com/fhg/fhg022008-story01.html
On Thu, Sep 27, 2012 at 12:16 PM, Jeffrey Day<Jeff.Day@xxxxxxxx> wrote:
Hi Folks,
Our MySQL server was installed on our IBM i a short while ago, and
everything appeared to be working. I was working on importing a
database from a different MySQL server implementation when I began
getting the following error message when I tried to login into
phpMyAdmin. "#2002 - The server is not responding (or the local
MySQL server's socket is not correctly configured)". This does
not seem to be true though, because the socket, mysql.default_socket, is set to /tmp/mysql.sock.
At this point, MySQL is unuseable as I cannot login to it, but PHP
is working fine.
Other symptoms I am seeing are when I try to start the MySQL
daemon, it starts and ends right away. It gens 2 spoolfiles. One
that just has this text in it "-n Starting MySQL ...". The second,
a joblog, which says it ran "CALL PGM(QP2SHELL)
PARM('/QOpenSys/usr/bin/sh/usr/local/MySQL/bin/mysql.sh
start')" and completed with endcode 0.
Does anyone know a solution for this problem? Is my only option
to reinstall? I have found Mike Pavlak's instructions for how to
remove MySQL and I have downloaded the DBi savefile from Zend, but
I'd like to here if there is a better way before I proceed with the re-install.
Thanks,
Jeff
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
This message has been scanned for viruses by MailControl - www.mailcontrol.com
Click
https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== to report this email as spam
If the reader of this email is not the intended recipient(s), please be advised that any dissemination, distribution or copying of this information is strictly prohibited. Johnson Matthey PLC has its main place of business at 5th Floor, 25 Farringdon Street, London (020 7269 8400).
Johnson Matthey Public Limited Company
Registered Office: 5th Floor, 25 Farringdon Street, London EC4A 4AB
Registered in England No 33774
Whilst Johnson Matthey aims to keep its network free from viruses you should note that we are unable to scan certain emails, particularly if any part is encrypted or password-protected, and accordingly you are strongly advised to check this email and any attachments for viruses. The company shall NOT ACCEPT any liability with regard to computer viruses transferred by way of email.
Please note that your communication may be monitored in accordance with Johnson Matthey internal policy documentation.
This message has been scanned for viruses by MailControl - www.mailcontrol.com
midrange.com
