I need to make a copy of my project for testing and developement. However, my database hoster is very weak and there are always gateway timeouts, so this time I try to only export and import the necessary tables.

I noticed that there are some very big tables:

enter image description here

Can I exclude their data and only export the structure or is the data essential for magento to work?

Which tables can I exclude which are essential?

More infos


innodb_lock_wait_timeout is set to "240"

  • Does no one know it?
    – Black
    May 28, 2018 at 7:23

1 Answer 1


Make a dump through SSH mysqldump -u username -p dbname > db_dump.sql.

  • This does not answer my question. I don't have the password, I can only access Phpmyadmin.
    – Black
    May 26, 2018 at 9:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.