- Posts: 5
COMMUNITY FORUM
Restore K2 Articles
- hqbefree
- Topic Author
- Offline
- New Member
Less
More
4 years 6 months ago - 4 years 6 months ago #175675
by hqbefree
Restore K2 Articles was created by hqbefree
Dear Admin and All
I though if I uninstall the K2 and reinstall the newest K2, I will got all standard setting again. But I lost all my items after install K2 :-(
I had tryed more time to restore my backup from lima-city. But nothing show. All the items are gone :-(
But if I search in my joomla: root / media / k2 / items / src and cache
I can see all the pictures are here.
Please help
How can I restore all the articles with media (pictures, text) back?
Link: quangharvest.com/loi-chua-quyen-nang/
Thank you for every tips and help
kind regard
hq
K2 v2.10.3
Joomla! 3.9.18
I though if I uninstall the K2 and reinstall the newest K2, I will got all standard setting again. But I lost all my items after install K2 :-(
I had tryed more time to restore my backup from lima-city. But nothing show. All the items are gone :-(
But if I search in my joomla: root / media / k2 / items / src and cache
I can see all the pictures are here.
Please help
How can I restore all the articles with media (pictures, text) back?
Link: quangharvest.com/loi-chua-quyen-nang/
Thank you for every tips and help
kind regard
hq
K2 v2.10.3
Joomla! 3.9.18
Last edit: 4 years 6 months ago by hqbefree.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 6 months ago #175683
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Restore K2 Articles
When you uninstall K2 (as with software in general) expect all its data to be deleted. So media files in /media/k2/ and K2's database tables are erased.
As such, you'd need to restore a full backup and then perform the upgrade via the Joomla update manager.
As such, you'd need to restore a full backup and then perform the upgrade via the Joomla update manager.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- hqbefree
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
4 years 6 months ago #175688
by hqbefree
Replied by hqbefree on topic Restore K2 Articles
Dear Fotis
Thank you very much for your tip
I really tryed. I restored full backup from more than last backup. I install the K2 newest. I can see all the media in k2, but no item see in K2 Components.
I can sending you administrator and ftp details to check it.
I have change a new template since a week. I give up :-( I really dont know to to restore k2 items again. And each time after restore backup I must rebuild all other joomla new articles and modules changes :-(
Thank you very much for your tip
I really tryed. I restored full backup from more than last backup. I install the K2 newest. I can see all the media in k2, but no item see in K2 Components.
I can sending you administrator and ftp details to check it.
I have change a new template since a week. I give up :-( I really dont know to to restore k2 items again. And each time after restore backup I must rebuild all other joomla new articles and modules changes :-(
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 6 months ago #175690
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Restore K2 Articles
Check your database. If you see any K2 tables without 0 entries, then the data is there. If you don't, it's gone and the backup you have is probably outdated.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- quang
- Offline
- New Member
Less
More
- Posts: 17
4 years 6 months ago #175691
by quang
Replied by quang on topic Restore K2 Articles
Dear Fotis
Yes, I see alot of Zero in K2 Database.
Should I restore MySQL-Database-Backups from another days like April?
What happend with all the Joomla new articles change now? Do I lost them?
Thanks
Yes, I see alot of Zero in K2 Database.
Should I restore MySQL-Database-Backups from another days like April?
What happend with all the Joomla new articles change now? Do I lost them?
Thanks
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 6 months ago #175698
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Restore K2 Articles
I don't understand why you continue a topic started by @hqbefree. Make a new one please and provide more context.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- hqbefree
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
4 years 6 months ago #175700
by hqbefree
Replied by hqbefree on topic Restore K2 Articles
Dear Fotis
Its me hqbefree. The webbrowser automatic refill my 2.account. Sorry for irrationally.
I check under sql database. I see alot of K2 are as 0.
My question is: 1.) Should I restore a SQL Database from 28.April, the date before I uninstalled K2. Only the SQL-Database. Not again the hold Webspace backup.
2.) What happens with all my new Joomla articles and modules changes? Are they lost after restore SQL Database from 28. April?
Thanks again for your advise and instruction.
Its me hqbefree. The webbrowser automatic refill my 2.account. Sorry for irrationally.
I check under sql database. I see alot of K2 are as 0.
My question is: 1.) Should I restore a SQL Database from 28.April, the date before I uninstalled K2. Only the SQL-Database. Not again the hold Webspace backup.
2.) What happens with all my new Joomla articles and modules changes? Are they lost after restore SQL Database from 28. April?
Thanks again for your advise and instruction.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 6 months ago #175703
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Restore K2 Articles
If you can get a backup from your CURRENT database, create a NEW database first and then using phpMyAdmin, import the backup to the NEW database.
In the NEW database choose to export ONLY the K2 related tables. This will create a new .sql file which contains only K2 data.
Now go to your CURRENT database and delete all K2 tables (which are empty either way). Then import (again, using phpMyAdmin) the K2 tables you previously exported, into your CURRENT database.
This will restore your deleted K2 data without messing with anything else in your Joomla site.
Remember to grab a backup of your CURRENT database before doing anything, in case something goes wrong.
In the NEW database choose to export ONLY the K2 related tables. This will create a new .sql file which contains only K2 data.
Now go to your CURRENT database and delete all K2 tables (which are empty either way). Then import (again, using phpMyAdmin) the K2 tables you previously exported, into your CURRENT database.
This will restore your deleted K2 data without messing with anything else in your Joomla site.
Remember to grab a backup of your CURRENT database before doing anything, in case something goes wrong.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- hqbefree
- Topic Author
- Offline
- New Member
Less
More
- Posts: 5
4 years 6 months ago #175714
by hqbefree
Replied by hqbefree on topic Restore K2 Articles
Dear Fotis
Thank you so much for your instruction. It all news for me, but I try to learn.
Now I know how to export and import sql database with alot of trouble!
I have created a new database and my current database. I could import the current database now.
There are a lot of K2 tables. I hope I could found every K2 related tables.
I dont want to lost everything again. So I decided to download the backup and the database on my harddisk.
I try with XAMPP first.
I have my full website data on host and a database created.
TROUBLE: I try under the configurate.php
public $list_limit = '20';
public $access = '1';
public $dbtype = 'mysqli';
public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'quangharvest28april2020';
public $dbprefix = 'dfaa_';
public $secret = '';
public $gzip = '1';
public $error_reporting = 'default';
public $helpurl = 'help.joomla.org/proxy?keyref=Help{major}{minor}:{keyref}&lang={langcode}';
public $ftp_host = '127.0.0.1';
public $ftp_port = '21';
public $ftp_enable = '0';
public $tmp_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/tmp';
public $log_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/logs';
I GOT THIS WARNING:
Warning: session_start(): Failed to read session data: user (path: G:\Alle Programme\xampp\tmp) in G:\Alle Programme\xampp\htdocs\quangharvest\default-website\libraries\joomla\session\handler\native.php on line 260
Error: Failed to start application: Failed to start the session
I cant do anything more. I search a lot of support on google. But I nothing help.
Please tell me what to do.
I dont set any password on host phpMyAdmin. So I hope the username: root and pw: `"nothingspace" korrect?
Thank you so much for your instruction. It all news for me, but I try to learn.
Now I know how to export and import sql database with alot of trouble!
I have created a new database and my current database. I could import the current database now.
There are a lot of K2 tables. I hope I could found every K2 related tables.
I dont want to lost everything again. So I decided to download the backup and the database on my harddisk.
I try with XAMPP first.
I have my full website data on host and a database created.
TROUBLE: I try under the configurate.php
public $list_limit = '20';
public $access = '1';
public $dbtype = 'mysqli';
public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'quangharvest28april2020';
public $dbprefix = 'dfaa_';
public $secret = '';
public $gzip = '1';
public $error_reporting = 'default';
public $helpurl = 'help.joomla.org/proxy?keyref=Help{major}{minor}:{keyref}&lang={langcode}';
public $ftp_host = '127.0.0.1';
public $ftp_port = '21';
public $ftp_enable = '0';
public $tmp_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/tmp';
public $log_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/logs';
I GOT THIS WARNING:
Warning: session_start(): Failed to read session data: user (path: G:\Alle Programme\xampp\tmp) in G:\Alle Programme\xampp\htdocs\quangharvest\default-website\libraries\joomla\session\handler\native.php on line 260
Error: Failed to start application: Failed to start the session
I cant do anything more. I search a lot of support on google. But I nothing help.
Please tell me what to do.
I dont set any password on host phpMyAdmin. So I hope the username: root and pw: `"nothingspace" korrect?
Please Log in or Create an account to join the conversation.
- JoomlaWorks
- Offline
- Admin
Less
More
- Posts: 6218
4 years 6 months ago #175727
by JoomlaWorks
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by JoomlaWorks on topic Restore K2 Articles
It depends on how XAMPP was setup in the first place. If you use an empty password for the "root" user in MySQL, then the credentials are fine. However do check that everything else database-related is correct as well (database name, database prefix).
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.