NYCPHP Meetup

NYPHP.org

[joomla] reconnect to mysql database

Helvécio da Silva helvecio.rj at gmail.com
Wed Oct 6 15:47:40 EDT 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20101006/2d51d700/attachment.html>


More information about the Joomla mailing list