ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down.
Read our Farewell Blog Post for more details.
SOLVED - import articles/categories/menus into database?
-
-
- nemmar
- Sr. Rocketeer
- Posts: 221
- Thanks: 0
-
I used RocketLauncher to install the Momentum template on a new Joomla site with all the sample data so it replicates the demo site. I then created menu items, categories and added about 100 articles. After that I realized that I want to use the Camber template (with the demo site data) instead of the Momentum template.
I would like to do the following so let me know if it's possible, and if yes, then and what steps to take:
1) Export my articles/categories/menu items from the current database.
2) Then empty or drop the database tables on the server so it's ready for a new install.
3) Then use RocketLauncher to install the Camber template with the sample data like the demo site.
4) Then import my articles/categories/menu items from the exported database file into the current database on the new Camber site.
The posts I've found on this forum mention that you don't use RocketLauncher unless it's an empty database for a new install. I didn't find any posts about importing some data after using RocketLauncher, so if I missed them just let me know the URL to read the details.
Thanks for any advice! - Last Edit: 13 years 5 months ago by nemmar.
- NOTE to forum mods: Right-Click is disabled on my site but source code is visible. Unfortunately, I have some images on my site that are licensed and the agreement is that right-click be disabled. I use the F12 key for Firebug instead of right-click. Sorry for the inconvenience.
-
-
-
- Ben Simon
- Elite Rocketeer
- Posts: 4301
- Thanks: 8
- Full-time web developer
-
A database manager should let you export and then import the relevant db tables. I could give you instruction for phpmyadmin if that's what you use.
Disclaimer: I've only used this method for articles. - B
e courteous to staff and members that volunteer their time helping you
E ssential Tool - FireBug
N ever assume I know what version you're talking about
S earch the forum for a solution first
I nclude a link to the problem
M ark your resolved issues as [SOLVED]
O nly PM moderators if they request it first
N o...
-
-
-
- nemmar
- Sr. Rocketeer
- Posts: 221
- Thanks: 0
-
Ben,
Okay, if you can outline the steps with PhpMyAdmin then I can give it a try. I have a backup copy of the database so I'll see if the importing works.
If I can, I will just import the articles to make it easier. Do I just need to first create the same categories and menu items in the new database before importing the articles? Will the articles then be assigned to the same category/menu items that they were in the old database?
I think I just need to export the correct tables and then import them into the new database to add the content to the existing database content. Let me know what tables and the steps.
Thanks! - NOTE to forum mods: Right-Click is disabled on my site but source code is visible. Unfortunately, I have some images on my site that are licensed and the agreement is that right-click be disabled. I use the F12 key for Firebug instead of right-click. Sorry for the inconvenience.
-
-
-
- Ben Simon
- Elite Rocketeer
- Posts: 4301
- Thanks: 8
- Full-time web developer
-
In phpmyadmin navigate to the database, select Export. Choose the custom method with the following settings.
ROWS:
Dump all rows
OUTPUT:
Save output to a file > File name template: > @TABLE@
Format:
SQL
FORMAT-SPECIFIC OPTIONS:
Display comments (includes info such as export timestamp, PHP version, and server version)
Dump table > structure and data
OBJECT CREATION OPTIONS:
Add CREATE PROCEDURE / FUNCTION statement
CREATE TABLE options: IF NOT EXISTS and AUTO_INCREMENT
Enclose table and field names with backquotes (Protects field and table names formed with special characters or keywords)
DATA DUMP OPTIONS:
Function to use when dumping data: > INSERT
Syntax to use when inserting data: > both of the above
Dump binary columns in hexadecimal notation (for example, "abc" becomes 0x616263)
Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)
I'm running phpMyAdmin 3.4.5. Your settings might look slightly different.
Import the saved database next to the target database (they're not synced yet). Right now I would personally delete everything but the tables I want to sync within the imported database. That would be everything but _content in this case. Go to phpmyadmin home and select Synchronize. Choose the appropriate origin and target databases then Synchronize. - B
e courteous to staff and members that volunteer their time helping you
E ssential Tool - FireBug
N ever assume I know what version you're talking about
S earch the forum for a solution first
I nclude a link to the problem
M ark your resolved issues as [SOLVED]
O nly PM moderators if they request it first
N o...
-
-
-
- nemmar
- Sr. Rocketeer
- Posts: 221
- Thanks: 0
-
Ben,
Okay, I'll test this out. Thank you very much for the information! - NOTE to forum mods: Right-Click is disabled on my site but source code is visible. Unfortunately, I have some images on my site that are licensed and the agreement is that right-click be disabled. I use the F12 key for Firebug instead of right-click. Sorry for the inconvenience.
-
Time to create page: 0.084 seconds