do I need to reinstall Apache for each new joomla site I develop?
-
-
- Ben Lee
- Elite Rocketeer
- Posts: 4193
- Thanks: 42
-
OK, I think this might help, but I'm not an expert at this stuff at all. This is just where those settings are in phpMyAdmin and how you can change them if needed:
Go to phpMyAdmin for the Database that you need to Export.
Click on the "Structure" tab at the top main page. This should show you all the tables for your database...a default Joomla install is 37 I think, so depending on add-ons, you could have more.
Scroll all the way down to the bottom of the page. The last line in the table list should sum up everything for that database. Here's what one of mine looks like:FYI: The default for mine was "utf8_unicode_ci" and I changed it to "utf8_general_ci" to see if it would break the site and everything still works fine. Also note that all my tables are "utf8_bin". The settings I'm describing here change it for the overall database, not the individual table.75 table(s) Sum 3,250 MyISAM utf8_general_ci 659.6 KiB 2.5 KiB
In the same place you see the "utf8_general_ci" on this line, write down what you have.
Scroll all the way back up to the top and click on the "Operations" tab.
The bottom option on the "Operations" tab is "Collation". In that dropdown, you should see all the options there. Depending on the server or local host set up, you may have a different default.
When you go to import to the new database, go to this same part to make the two the same thing. Just choose the same Collation there and hit Go and it should run the query and set it for you. You either want to do this for the one you are exporting, then export it after, or for the one you're importing and make sure it matches the export.
-
-
-
- studio1c
- Hero Rocketeer
- Posts: 277
- Thanks: 1
-
Jem, thank you for the Joomla Pack info. I am looking into that as a possibility to streamline this process as well. Much appreciated.
Ben, I followed you and got to the new site, selected the db from the left menu that I wanted, went to the top, clicked import and an even longer error message came up. *sigh* Do I need to export then import both databases (main one and info schema) separately?
ERROR
SQL query:
-- -- Database: `elfpartner` -- --
-- -- Table structure for table `jos_banner` -- CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL default '0', `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL default '0[...]
MySQL said: Documentation
#1050 - Table 'jos_banner' already exists
-
-
-
- studio1c
- Hero Rocketeer
- Posts: 277
- Thanks: 1
- Jem, I have backed up the original remote site and have installed the new 2nd remote site. How do I "unpack" the elements into the 2nd site so it's a duplicate and have the database info in there?
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
Sorry, I don't I don't understand the question.
If you follow the instructions and run the the JoomlaPack installer it should automatically duplicate the original site.
JEM wrote:Create the site you want to duplicate.
Get JoomlaPack
www.joomlapack.net/
Install it on that site.
Create a backup
Navigate to the backup
Extract it to a new folder in htdocs
Create a new DB for the new install
Navigate to that folder and run the install
Same procedure for localhost to live site
More notes here:
www.rockettheme.com/forum/index.php?f=15...dirty&rb_v=viewtopic - Thanks,
jim
-
-
-
- kfawcett
- Sr. Rocketeer
- Posts: 133
- Thanks: 0
- Information Systems Consultant
-
@ Michelle
I found this interesting tidbit on the JoomlaPack site:
Did you know?
JoomlaPack can be set up to omit arbitrary database tables from the backup set. This allows you to backup, for example, a site which shares the same physical database with another Joomla! site or another non-Joomla! script.
Also you might look at this page to help with the transfer. http://www.joomlapack.net/help-support-documentation/joomlapack-2x-documentation/kickstart.html
Kickstart is a PHP executable file (script) use to partially automate the steps required before and after the restoration of site backed up with JoomlaPack. It can be used either standalone or in conjunction with the JoomlaPack component. In fact, the component uses Kickstart for the restoration feature of full site backups.
Kickstart streamlines the archive extraction - uploading - restoration - post-restoration workflow by allowing you to omit unnecessary steps. As a matter of fact, you only need to upload Kicstart and the backup archive on the server you want to restore your site to. Kickstart will extract (i.e. "unzip") the archive right on the server, rename your .htaccess and give you a link to start the restoration script (for example, JoomlaPack Installer 3). When you're done with the restoration script, you click on the second link Kickstart provides and it will rename back your .htaccess file, remove the installation directory, delete the backup archive and finally remove itself as well. Housekeeping is taken care of itself! - Rate your web host! ExploreWebHosting.com
-
-
-
- kfawcett
- Sr. Rocketeer
- Posts: 133
- Thanks: 0
- Information Systems Consultant
- Be aware that you will need to most likely use the newest beta version of JoomlaPack for Joomla 1.5
- Rate your web host! ExploreWebHosting.com
-
Time to create page: 0.058 seconds