Warning: count(): Parameter must be an array or an object that implements Countable in /www/membershipdemo_264/public/wp-content/plugins/slider-by-supsystic/vendor/Rsc/Menu/Page.php on line 228 Export Database – Membership: bbPress Integration
Once you have selected the correct database, click on Export in the top navigation menu.
Next, you will be provided with options for the Export Method.
Select Custom. This will show additional export options.
From the Tables box, click Select All to ensure that all of the tables are exported. Scroll further down the options list to the Format heading.
Then pick SQL as the export format.
In the Object Creation Options subsection, select the following check boxes:
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
CREATE TABLE statement
CREATE TABLE Options
IF NOT EXISTS
Enclose table and field names with backquotes
The final piece to consider is Maximal Length of Created Query, which is found at the bottom of the Export page.
For databases over 300MBs I highly recommend you alter the Maximal Length of Created Query to 1047551.