[joomla] reconnect to mysql database
Paul Elliott
joomlanyc at upshotmagazine.com
Wed Oct 6 16:36:13 EDT 2010
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
More information about the Joomla
mailing list