restoring a backup. (editing database location)
Okay, so I got the MYSQL database (about 10mb) backedup and I can restore it...
But I made a backup of the softaculous install (a tar.gz) which seems to have all of the FTP files inside, EXCEPT it has a bonus folder called "Softdatadir" that i assume, has all the pictures and stuff in it...
So how do i get that to the new server? Since "Softdatadir" doesnt show up in FTP, i assume it exists in some place outside of FTP and MySQL that I dont know about. (Cuz I'm a noob with this sort of thing xD)
If i try to STRAIGHT backup the tar.gz it says this: (From antserve to elementfx)
Installation has been removed, which was installed on the following url : http://tricksteronline.antserve.net/elgg. You can restore it using the Backup. elgg.138_31669.2013-03-19_21-51-54.tar.gz 332.43 MB 1.8.14
http://trickster.elementfx.com/elgg elgg.138_78857.2013-03-20_04-14-28.tar.gz 2.88 MB 1.8.13
Which i assume it doesnt work because the databases configured in mysql aren't the same
and im not sure how to edit it :/
So in conclusion: 2 questions here
1.) How do I change the databases (in the tar.gz file) from Antserve to match the new ElementFX?
or
2.) Where the heck does softdatadir go, if i doesnt go via FTP?
Edit: OKAY i found out it goes in "elggdata" folder, straight up. Woot!
Now i just need to know where the database info is stored so i can change it from antserve to elementfx :D
Thanks in advance <3
- Matt Beckett@Beck24
Matt Beckett - 0 likes
- Caiterz@Caiterz
Caiterz - 0 likes
- Caiterz@Caiterz
Caiterz - 0 likes
- Caiterz@Caiterz
Caiterz - 0 likes
- Caiterz@Caiterz
Caiterz - 0 likes
You must log in to post replies.Database info is found in the file:
Thank you ^___^ the settings seems to work great... and i believe i got my mysql database imported back in correctly... however...
When i try to go to my page...
Fatal Error.
An unrecoverable error has occurred and has been logged. Contact the site administrator with the following information:
Exception #1363766599.
----
[20-Mar-2013 04:03:28 America/New_York] Exception #1363766608: exception 'DatabaseException' with message 'Elgg couldn't select the database 'tricky01_elgg197', please check that the database is created and you have access to it.' in /home/tricky01/public_html/elgg/engine/lib/database.php:113
Stack trace:
#0 /home/tricky01/public_html/elgg/engine/lib/database.php(148): establish_db_link('readwrite')
#1 /home/tricky01/public_html/elgg/engine/lib/elgglib.php(2144): setup_db_connections()
#2 [internal function]: _elgg_engine_boot('boot', 'system', NULL)
#3 /home/tricky01/public_html/elgg/engine/lib/elgglib.php(775): call_user_func_array('_elgg_engine_bo...', Array)
#4 /home/tricky01/public_html/elgg/engine/start.php(99): elgg_trigger_event('boot', 'system')
#5 /home/tricky01/public_html/elgg/index.php(12): require_once('/home/tricky01/...')
#6 {main}
---
andd... when i made the new database table in PHPMYADMIN (via restoring localhost.sql) it does NOT show up in MYSQL Database.. (even with refresh or a different browser) and if i try to CREATE it, it says "Already exists"
http://ft.trillian.im/b5fbe83b5f6825ccfc7c8392dccb383714df92ec/6ffRVgJcCdQoTHAY1EjEtJFnH6TQu.jpg
http://ft.trillian.im/b5fbe83b5f6825ccfc7c8392dccb383714df92ec/6ffRNJEGzavGK30eCPLCroKVGoumD.jpg
^ see :o
Could this be related to the error? Maybe because I havent added the user to it? how do i get it to show up in MySQL Database so I can add it? (Instructions to a noob, as to where to click to type things and etc XD)
Thanks!
---
Also, someone suggested to import it to a database that's already created. Doesn't work.
http://ft.trillian.im/b5fbe83b5f6825ccfc7c8392dccb383714df92ec/6ffU9iDa56avGg97vSwKKmAjUkL9v.jpg
OK um... we edited localhost.sql and just took "Create DB" out, and it seemed to import fine..
and no broken images or anything, looked GREAT...
But then... >_< It was still pointed towards the OLD website.. antserve.net...
So i went through localhost.sql and replaced OLD website with NEW website...
now everything is broken...
http://trickster.elementfx.com/elgg/
Including the CSS file.
the css file (In cache) doesnt show up in FTP.. So how can I fix the CSS and these broken links?
(Like basically anything in the DB and not FTP is broken.. like http://trickster.elementfx.com/elgg/photos/thumbnail/2000/thumb/ too)
Thanks so much :3
and sorry, for some reason my edit button is missing in action :x
---
I got my login and looks like most/all of the pictures working... but the css file STILL isnt working.. even after upgrade.php and flushing cache.
---
Here's my comments on each step of the "How to move servers" tutorial...
Maybe i messed something up here o.o
Editbutton dissapeared again..
Apparently i cant delete views_simplecache folder..
The folder MUST be there..
So i put the folder BACK IN (only empty) and everything appears to be working 100%.
Thanks to everyone that helped me ^_^
And hopefully if others have these issues in the future, they can see what i did and fix the issues themselves.
<3