[joomla] reconnect to mysql database
Stephen Britton
steve at sbritton.com
Wed Oct 6 16:47:52 EDT 2010
Paul. Please tell me what you are trying to do? Choose A or B or is it
something else?
A) Are you moving the Joomla website from one server to another server?
B) Is the Joomla site on the same server and you moved it to a
different part of the server or did you delete the old Joomla site and
reinstalled a new one?
I am assuming that you are trying to do A. If that is the case, here
is a tutorial that worked for me. It's old, but PHPMyAdmin hasn't
changed much in the past four years.
http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin
On Wed, Oct 6, 2010 at 4:36 PM, Paul Elliott
<joomlanyc at upshotmagazine.com> wrote:
> So how would i do it right?
>
> On Oct 6, 2010, at 4:32 PM, Stephen Britton wrote:
>
>> If you can't see the data in PHPAdmin than the data was not imported properly.
>>
>> Tell me more... Is this website on a different server from the old one?
>>
>> If you moved the site to a different server: How did you export the
>> database from the previous server and how did you import it into the
>> new one?
>>
>>
>> On Wed, Oct 6, 2010 at 4:05 PM, Paul Elliott
>> <joomlanyc at upshotmagazine.com> wrote:
>>> I'm sure i could.
>>> What options would those give?
>>> I still see data missing in phpadmin
>>> On Oct 6, 2010, at 3:47 PM, Helvécio da Silva wrote:
>>>
>>> Can you export the previous database again through PHPMyAdmin using REPLACE
>>> or UPDATE under EXPORT TYPE?
>>>
>>> EXPORT TAB > EXPORT TYPE > REPLACE or UPDATE
>>>
>>> 2010/10/6 Paul Elliott <joomlanyc at upshotmagazine.com>
>>>>
>>>> I'm browsing bak_users in phpadmin, all i see is the super admin.
>>>> When i first started working on this a few days ago, i did a new install
>>>> and assigned it to the previous mysql database during install.
>>>> Could that have erased any of the data?
>>>> On Oct 6, 2010, at 1:15 PM, Donna Marie Vincent wrote:
>>>>
>>>> Isn't there a debugger that can be turned on that displays the sql query
>>>> statements and results?
>>>>
>>>> ________________________________
>>>> From: Paul Elliott <joomlanyc at upshotmagazine.com>
>>>> To: NYPHP SIG: Joomla <joomla at lists.nyphp.org>
>>>> Sent: Wed, October 6, 2010 12:54:26 PM
>>>> Subject: Re: [joomla] reconnect to mysql database
>>>>
>>>> Helvécio,
>>>> I followed your directions.
>>>> After logging into the admin, i went to users.
>>>> I dont see any of the names but the super admin.
>>>>
>>>> On Oct 6, 2010, at 9:15 AM, Helvécio da Silva wrote:
>>>>
>>>> Try this:
>>>>
>>>> 1. Do a clean install of Joomla (no sample data)
>>>> 2. In PHPMyAdmin control panel, choose the database this new install is
>>>> using
>>>> 3. Go to the IMPORT tab, choose your previous database and upload it
>>>> 4. That should do the trick! Previous members and passwords wil be there,
>>>> as well as all the rest of the content.
>>>>
>>>> 2010/10/6 Paul Elliott <joomlanyc at upshotmagazine.com>
>>>>>
>>>>> Both front and back end.
>>>>> No i dont see the articles.
>>>>> Same template.
>>>>> On Oct 6, 2010, at 8:45 AM, Donna Marie Vincent wrote:
>>>>>
>>>>> Where are you not seeing the old data, in the admin, on the public facing
>>>>> side? When you go into the list of articles in admin, do you see the old
>>>>> articles? Are you using a different template with a different layout?
>>>>>
>>>>> ________________________________
>>>>> From: Paul Elliott <joomlanyc at upshotmagazine.com>
>>>>> To: NYPHP SIG: Joomla <joomla at lists.nyphp.org>
>>>>> Sent: Wed, October 6, 2010 8:33:30 AM
>>>>> Subject: Re: [joomla] reconnect to mysql database
>>>>>
>>>>> Hi Donna,
>>>>> I do still have the database used for the previous install.
>>>>> The new install is set to it in configuration.php
>>>>> The problem is that i still don't see any of the previous database
>>>>> information on the new site.
>>>>> On Oct 6, 2010, at 8:18 AM, Donna Marie Vincent wrote:
>>>>>
>>>>> In "configuration.php", you can set the db name, db password and db
>>>>> username. Set it to the database used for the previous install, assuming
>>>>> you still have that info. That info would be in the configuration.php file
>>>>> of the previous install.
>>>>>
>>>>> If you don't have that info, you can open your webhosting control panel
>>>>> and create another username and password for that database.
>>>>>
>>>>>
>>>>> ________________________________
>>>>> From: Paul Elliott <joomlanyc at upshotmagazine.com>
>>>>> To: NYPHP SIG: Joomla <joomla at lists.nyphp.org>
>>>>> Sent: Wed, October 6, 2010 8:08:57 AM
>>>>> Subject: [joomla] reconnect to mysql database
>>>>>
>>>>> Hello,
>>>>> I am trying to connect a new joomla installation to the mysql database of
>>>>> a previous install.
>>>>> The install was successful but i don't see any of the original data
>>>>> after.
>>>>> I even dragged content (i.e.- components, images, modules, plugins,
>>>>> admin, etc.) from the previous install via ftp and none of it shows up.
>>>>> Does anyone know how to connect to the content in the previous installs
>>>>> mysql database?
>>>>> Thanks,
>>>>> Paul
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com/
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>>
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>>
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>
>>>>
>>>>
>>>> --
>>>> Helvecio "Elvis" da Silva
>>>> Rio de Janeiro - Brasil - helvecio.rj at gmail.com
>>>> http://www.helvecio.com/ - http://blog.helvecio.com/
>>>>
>>>> _______________________________________________
>>>> New York PHP SIG: Joomla! Mailing List
>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>
>>>> NYPHPCon 2006 Presentations Online
>>>> http://www.nyphpcon.com
>>>>
>>>> Show Your Participation in New York PHP
>>>> http://www.nyphp.org/show_participation.php
>>>>
>>>> _______________________________________________
>>>> New York PHP SIG: Joomla! Mailing List
>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>
>>>> NYPHPCon 2006 Presentations Online
>>>> http://www.nyphpcon.com
>>>>
>>>> Show Your Participation in New York PHP
>>>> http://www.nyphp.org/show_participation.php
>>>>
>>>> _______________________________________________
>>>> New York PHP SIG: Joomla! Mailing List
>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>
>>>> NYPHPCon 2006 Presentations Online
>>>> http://www.nyphpcon.com
>>>>
>>>> Show Your Participation in New York PHP
>>>> http://www.nyphp.org/show_participation.php
>>>
>>>
>>>
>>> --
>>> Helvecio "Elvis" da Silva
>>> Rio de Janeiro - Brasil - helvecio.rj at gmail.com
>>> http://www.helvecio.com - http://blog.helvecio.com
>>>
>>> _______________________________________________
>>> New York PHP SIG: Joomla! Mailing List
>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>
>>> NYPHPCon 2006 Presentations Online
>>> http://www.nyphpcon.com
>>>
>>> Show Your Participation in New York PHP
>>> http://www.nyphp.org/show_participation.php
>>>
>>> _______________________________________________
>>> New York PHP SIG: Joomla! Mailing List
>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>
>>> NYPHPCon 2006 Presentations Online
>>> http://www.nyphpcon.com
>>>
>>> Show Your Participation in New York PHP
>>> http://www.nyphp.org/show_participation.php
>>>
>>
>>
>>
>> --
>> Stephen Britton
>> Technology Consultant
>> sbritton at gmail.com
>> ph: 914-661-0040
>> _______________________________________________
>> New York PHP SIG: Joomla! Mailing List
>> http://lists.nyphp.org/mailman/listinfo/joomla
>>
>> NYPHPCon 2006 Presentations Online
>> http://www.nyphpcon.com
>>
>> Show Your Participation in New York PHP
>> http://www.nyphp.org/show_participation.php
>
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
--
Stephen Britton
Technology Consultant
sbritton at gmail.com
ph: 914-661-0040
More information about the Joomla
mailing list