How to export the contents of existing database to another?
-
-
- Shayon Pal
- Jr. Rocketeer
- Posts: 44
- Thanks: 0
-
Currently, I have an existing Joomla website at
www.itmagz.com
that has it's own set of categories, sections and accordingly set up content.
I have installed the Terran Tribune Rocket Launcher into a test site at www.linuxasia.net/gen3 with it's demo content. Now, I wish to import the category and section names, along with the articles, into the new database of Terran Tribune. Any idea how to go about, with it? - A Wordpress Developer - forced to develop in Joomla
www.itmagz.com
-
-
-
- Jamesso
- Elite Rocketeer
- Posts: 500
- Thanks: 0
-
Shayon,
You can do this through phpmyadmin by exporting the database from the existing site and then importing it on the test site. You may need to change the database prefix in the configuration file.
Regards,
Jim -
Afterburner Mobile Template
Panels - Mynxx-Style Dropdown Display for Modules
Gridlock - A Custom Gantry Template
-
-
-
- Shayon Pal
- Jr. Rocketeer
- Posts: 44
- Thanks: 0
- Wel... my previous database had 55 tables while my current database has 80 tables. Are you sure the porting shall still work?
- A Wordpress Developer - forced to develop in Joomla
www.itmagz.com
-
-
-
- Jamesso
- Elite Rocketeer
- Posts: 500
- Thanks: 0
- The extra tables are for extensions that are being employed. If you you only overwrite the duplicate tables then you should be fine. You can always reinstall the RocketLauncher if it doesn't work. And I recommend you keep a backup of your existing site in a safe place. It's just good practice.
-
Afterburner Mobile Template
Panels - Mynxx-Style Dropdown Display for Modules
Gridlock - A Custom Gantry Template
-
-
-
- Shayon Pal
- Jr. Rocketeer
- Posts: 44
- Thanks: 0
-
Jamesso wrote:
The extra tables are for extensions that are being employed. If you you only overwrite the duplicate tables then you should be fine. You can always reinstall the RocketLauncher if it doesn't work.Well... shall try to import the tables. Let's see what happens.
Jamesso wrote:And I recommend you keep a backup of your existing site in a safe place. It's just good practice.Yup, of course!!
- A Wordpress Developer - forced to develop in Joomla
www.itmagz.com
-
-
-
- David Farmer
- Sr. Rocketeer
- Posts: 229
- Thanks: 1
-
I'm just trying to import an old database into a new installation of juxta using phpmyadmin but I get the message below. What am I doing wrong?
Error
SQL query:
-- -- Database: `davidfar_dramaresource09` -- --
-- -- Table structure for table `jos_banner` -- CREATE TABLE IF NOT EXISTS `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) [...]
MySQL said:
#1046 - No database selected
-
-
-
- jvdberg
- Rocketeer
- Posts: 66
- Thanks: 0
-
Quote:
Originally Posted by 1just4help View Post
MySQL said:
#1046 - No database selected
"No database selected" means that MySQL hasn't been told which database to run the SQL statements against. This shouldn't happen using phpMyAdmin because phpMyAdmin requires you to select the database before doing an import.
Perhaps you have a "USE DATABASE" statement in your .sql file that's overriding the normal operation, and needs to be removed.
Source: link
-
Time to create page: 0.412 seconds