{"id":59671,"date":"2016-01-13T08:48:59","date_gmt":"2016-01-13T13:48:59","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=59671"},"modified":"2018-09-21T08:15:52","modified_gmt":"2018-09-21T12:15:52","slug":"how-to-truncate-database-tables","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/how-to-truncate-database-tables.html","title":{"rendered":"How to truncate database tables"},"content":{"rendered":"<p>This tutorial provides a description of how to truncate database tables.<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=ttXx0-WIa6w?width=1280&amp;height=720\" rel=\"prettyPhoto\">Joomla 3.x. How to install engine and template on localhost<\/a>\r\n<p>In order to truncate database tables, you should do the following:<\/p>\r\n<ol>\r\n<li><p>Upload <a href=\"https:\/\/www.adminer.org\/\" target=\"_blank\" rel=\"nofollow\">adminer.php<\/a> script to the root directory on your server or access your database using hosting cpanel PhpMyAdmin tool.<\/p><\/li>\r\n<li><p>Connect to your database by opening your website URL + \/adminer.php in a browser (for example, www.my-website-url.com\/adminer.php) and filling in your database credentials:<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables-300x169.jpg\" alt=\"General._How_to_truncate_database_tables\" width=\"300\" height=\"169\" class=\"aligncenter size-medium wp-image-59672\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables-300x169.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li><p>Select the tables that you need to truncate (we will select all the tables as an example) and click <strong>Truncate<\/strong> button:<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables2.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables2-300x169.jpg\" alt=\"General._How_to_truncate_database_tables2\" width=\"300\" height=\"169\" class=\"aligncenter size-medium wp-image-59673\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables2-300x169.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables2-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/12\/General._How_to_truncate_database_tables2.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<\/ol>\r\n\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=ttXx0-WIa6w?width=1280&amp;height=720\" rel=\"prettyPhoto\">Joomla 3.x. How to install engine and template on localhost<\/a>\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/cart.php?addOffer=587\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-1-(500-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This tutorial provides a description of how to truncate database tables.<\/p>\n","protected":false},"author":94,"featured_media":59674,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1019],"tags":[545,1085,1519],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/59671"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=59671"}],"version-history":[{"count":1,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/59671\/revisions"}],"predecessor-version":[{"id":82807,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/59671\/revisions\/82807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/59674"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=59671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=59671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=59671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}