NYCPHP Meetup

[joomla] reconnect to mysql database

Paul Elliott joomlanyc at upshotmagazine.com
Wed Oct 6 16:05:17 EDT 2010


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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20101006/f1deb992/attachment.html>


More information about the Joomla mailing list