How to access Joomla DB?
I'm moving a site from GoDaddy hosting, and due to issues outside of Linode, I had to rebuild it by creating a new nanode and using the one-click Joomla deployment. Everything is going well, except I need to find a way to move my users to the new Joomla instance. I figured I would do this by inserting records into the Joomla DB, but I don't know how to access that. Previously I would have used PHPmyadmin, but I'm not sure what the equivalent is here, if there is one.
5 Replies
TTBOMK, users are stored in the database so you should 'dump' the MySQL database on GoDaddy (via phpMyAdmin) and make a new database on Linode and import the 'dump' file into it and then set Joomla to use it. (Note, I'm a WordPress user and not a Joom guy so this advice is worth what it cost you… probably less!)
I'm not a regular mysql user so you can take this with however much salt you care to apply…
I believe mysql stores user names (note that these are the mysql user names…not WP, Joomla, etc user names) as user@domain.com or user@ipaddress). These are unlikely to work on a new machine with a different domain.com or ipaddress.
However, once you restore the mysql database, you'll probably have to set up a single admin account and GRANT it all privileges over all the tables in the database (which would include the WP, Joomla, etc user table).
After this new admin account is set up, you can DELETE the old one.
-- sw
But how do I access the default Joomla database that's created from the the one-click Joomla Install? I can find it in files when I connected via SFTP, but what do I use to access and manage it? Is there an offering from Linode or is there something else people typically use?
Do you know the name and user and password of the database?
If you do, go ahead and install phpMyAdmin on the server and use that application from your local browser
Otherwise you will have to access the MySQL server via SSH in either your local terminal app or the Lish terminal in your Linode account.
I think you might be in a bit over your head on this and it might be wise to hire someone to get this done for you (but not me… we only do work and maintenance for WordPress sites. Joomla is a whole different animal!)
Yes, I setup the DB so I know the credentials. I'm just unfamiliar with how everything works on Linode, and I'm learning to use it. I'll try installing myPHPAdmin.
This is a very small website and I already have the old one running, so there isn't really any damage I can do, and I'm not getting paid for it, so hiring someone is out of the question.