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 '18 at 7:23

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 '18 at 9:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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