Database gone after killing mysql
Permalink
Hey.
This isn't my first installation of my concrete5-project, but I think I have to do it once again.
I've got problems with mysql (working on Mac os x 10.9) and had to kill the process manually. After starting mysql again, I wasn't able to access my databased (always got the "table doesn't exit error). And now comes my problem:
Instead of restarting my mac to figure out if it works again (the other databases are working again after restart), I tried to import the db dump I have exported a few weeks ago in the dashboard-area of concrete5. Unfortunately I have NOT copied my old database file in sequel pro, I've just the created sql-file of adminarea. After importing them into sequel pro I saw that there are just three tables in the sql-file. Okay. Not the problem. But it overwrite all the other tables in sequel pro (I still was in the view of my project-database).
Of course now I really can't access the webpage anymore. So: Is there any possibility or script or just anything to rebuild the tables without making a whole new installation and building the page from the beginning?
Please help!
Thanks
Vanessa
This isn't my first installation of my concrete5-project, but I think I have to do it once again.
I've got problems with mysql (working on Mac os x 10.9) and had to kill the process manually. After starting mysql again, I wasn't able to access my databased (always got the "table doesn't exit error). And now comes my problem:
Instead of restarting my mac to figure out if it works again (the other databases are working again after restart), I tried to import the db dump I have exported a few weeks ago in the dashboard-area of concrete5. Unfortunately I have NOT copied my old database file in sequel pro, I've just the created sql-file of adminarea. After importing them into sequel pro I saw that there are just three tables in the sql-file. Okay. Not the problem. But it overwrite all the other tables in sequel pro (I still was in the view of my project-database).
Of course now I really can't access the webpage anymore. So: Is there any possibility or script or just anything to rebuild the tables without making a whole new installation and building the page from the beginning?
Please help!
Thanks
Vanessa
This will keep all your packages in place, but the content will be gone, it's saved in the database. So are the files in the file manager because they are referenced from the database.