CINXE.COM

<!DOCTYPE html> <html lang="en-US"> <head> <meta charset="UTF-8" /> <title> Usage | BigDump: Staggered MySQL Dump Importer </title> <link rel="profile" href="https://gmpg.org/xfn/11" /> <link rel="stylesheet" type="text/css" media="all" href="https://www.ozerov.de/bigdump/wp-content/themes/twentyten/style.css?ver=20241112" /> <link rel="pingback" href="https://www.ozerov.de/bigdump/xmlrpc.php"> <meta name='robots' content='max-image-preview:large' /> <style>img:is([sizes="auto" i], [sizes^="auto," i]) { contain-intrinsic-size: 3000px 1500px }</style> <link rel="alternate" type="application/rss+xml" title="BigDump: Staggered MySQL Dump Importer » Feed" href="https://www.ozerov.de/bigdump/feed/" /> <link rel="alternate" type="application/rss+xml" title="BigDump: Staggered MySQL Dump Importer » Comments Feed" href="https://www.ozerov.de/bigdump/comments/feed/" /> <link rel='stylesheet' id='wp-block-library-css' href='https://www.ozerov.de/bigdump/wp-includes/css/dist/block-library/style.min.css?ver=6.7.2' type='text/css' media='all' /> <style id='wp-block-library-theme-inline-css' type='text/css'> .wp-block-audio :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-audio :where(figcaption){color:#ffffffa6}.wp-block-audio{margin:0 0 1em}.wp-block-code{border:1px solid #ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em 1em}.wp-block-embed :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-embed :where(figcaption){color:#ffffffa6}.wp-block-embed{margin:0 0 1em}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center}.is-dark-theme .blocks-gallery-caption{color:#ffffffa6}:root :where(.wp-block-image figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme :root :where(.wp-block-image figcaption){color:#ffffffa6}.wp-block-image{margin:0 0 1em}.wp-block-pullquote{border-bottom:4px solid;border-top:4px solid;color:currentColor;margin-bottom:1.75em}.wp-block-pullquote cite,.wp-block-pullquote footer,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase}.wp-block-quote{border-left:.25em solid;margin:0 0 1.75em;padding-left:1em}.wp-block-quote cite,.wp-block-quote footer{color:currentColor;font-size:.8125em;font-style:normal;position:relative}.wp-block-quote:where(.has-text-align-right){border-left:none;border-right:.25em solid;padding-left:0;padding-right:1em}.wp-block-quote:where(.has-text-align-center){border:none;padding-left:0}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote:where(.is-style-plain){border:none}.wp-block-search .wp-block-search__label{font-weight:700}.wp-block-search__button{border:1px solid #ccc;padding:.375em .625em}:where(.wp-block-group.has-background){padding:1.25em 2.375em}.wp-block-separator.has-css-opacity{opacity:.4}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto}.wp-block-separator.has-alpha-channel-opacity{opacity:1}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px}.wp-block-table{margin:0 0 1em}.wp-block-table td,.wp-block-table th{word-break:normal}.wp-block-table :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-table :where(figcaption){color:#ffffffa6}.wp-block-video :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-video :where(figcaption){color:#ffffffa6}.wp-block-video{margin:0 0 1em}:root :where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em 2.375em} </style> <style id='classic-theme-styles-inline-css' type='text/css'> /*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} </style> <style id='global-styles-inline-css' type='text/css'> :root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #fff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--color--blue: #0066cc;--wp--preset--color--medium-gray: #666;--wp--preset--color--light-gray: #f1f1f1;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgba(255,105,0,1) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgba(255, 255, 255, 1), 6px 6px rgba(0, 0, 0, 1);--wp--preset--shadow--crisp: 6px 6px 0px rgba(0, 0, 0, 1);}:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;} :where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;} :where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;} :root :where(.wp-block-pullquote){font-size: 1.5em;line-height: 1.6;} </style> <link rel='stylesheet' id='ce_responsive-css' href='https://www.ozerov.de/bigdump/wp-content/plugins/simple-embed-code/css/video-container.min.css?ver=2.5.1' type='text/css' media='all' /> <link rel='stylesheet' id='twentyten-block-style-css' href='https://www.ozerov.de/bigdump/wp-content/themes/twentyten/blocks.css?ver=20240703' type='text/css' media='all' /> <style id='akismet-widget-style-inline-css' type='text/css'> .a-stats { --akismet-color-mid-green: #357b49; --akismet-color-white: #fff; --akismet-color-light-grey: #f6f7f7; max-width: 350px; width: auto; } .a-stats * { all: unset; box-sizing: border-box; } .a-stats strong { font-weight: 600; } .a-stats a.a-stats__link, .a-stats a.a-stats__link:visited, .a-stats a.a-stats__link:active { background: var(--akismet-color-mid-green); border: none; box-shadow: none; border-radius: 8px; color: var(--akismet-color-white); cursor: pointer; display: block; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', 'Roboto', 'Oxygen-Sans', 'Ubuntu', 'Cantarell', 'Helvetica Neue', sans-serif; font-weight: 500; padding: 12px; text-align: center; text-decoration: none; transition: all 0.2s ease; } /* Extra specificity to deal with TwentyTwentyOne focus style */ .widget .a-stats a.a-stats__link:focus { background: var(--akismet-color-mid-green); color: var(--akismet-color-white); text-decoration: none; } .a-stats a.a-stats__link:hover { filter: brightness(110%); box-shadow: 0 4px 12px rgba(0, 0, 0, 0.06), 0 0 2px rgba(0, 0, 0, 0.16); } .a-stats .count { color: var(--akismet-color-white); display: block; font-size: 1.5em; line-height: 1.4; padding: 0 13px; white-space: nowrap; } </style> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://www.ozerov.de/bigdump/xmlrpc.php?rsd" /> <meta name="generator" content="WordPress 6.7.2" /> <link rel="canonical" href="https://www.ozerov.de/bigdump/usage/" /> <link rel='shortlink' href='https://www.ozerov.de/bigdump/?p=10' /> <link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://www.ozerov.de/bigdump/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.ozerov.de%2Fbigdump%2Fusage%2F" /> <link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://www.ozerov.de/bigdump/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.ozerov.de%2Fbigdump%2Fusage%2F&format=xml" /> <link rel="stylesheet" href="https://www.ozerov.de/bigdump/wp-content/plugins/highslide-4-wordpress-reloaded/highslide.min.css?ver=4113v128" type="text/css" media="screen" />  <link rel="shortcut icon" href="https://www.ozerov.de/favicon.ico" />  <script data-cookieconsent="analytics" async src="https://www.googletagmanager.com/gtag/js?id=UA-310799-1"></script> <script data-cookieconsent="analytics"> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-310799-1', { 'anonymize_ip': true }); </script> <script src="/fully-home/js/cookieconsent.js"></script> <script> window.CookieConsent.init({ theme: { barColor: '#2C7CBF', barTextColor: '#FFF', barMainButtonColor: '#FFF', barMainButtonTextColor: '#2C7CBF', modalMainButtonColor: '#4285F4', modalMainButtonTextColor: '#FFF', }, language: { current: 'en', locale: { en: { barMainText: 'This website uses cookies to ensure you get the best experience on our website.', barLinkSetting: 'Cookie Settings', barBtnAcceptAll: 'Accept all cookies', modalMainTitle: 'Cookie settings', modalMainText: 'Cookies are small piece of data sent from a website and stored on the user\'s computer by the user\'s web browser while the user is browsing. Your browser stores each message in a small file, called cookie. When you request another page from the server, your browser sends the cookie back to the server. Cookies were designed to be a reliable mechanism for websites to remember information or to record the user\'s browsing activity.', modalBtnSave: 'Save current settings', modalBtnAcceptAll: 'Accept all cookies and close', modalAffectedSolutions: 'Affected solutions:', learnMore: 'Learn More', on: 'On', off: 'Off', } } }, categories: { necessary: { needed: true, wanted: true, checked: true, language: { locale: { en: { name: 'Erforderliche Cookies', description: 'These cookies are requires for logins and saving your cookie settings', } } } }, various: { needed: false, wanted: false, checked: false, language: { locale: { en: { name: 'Analytics Cookies', description: 'These cookies are used for user analytics', } } } } }, services: { ga: { category: 'various', type: 'dynamic-script', search: 'analytics', cookies: [ { // Known cookie name. name: '_gid', // Expected cookie domain. domain: `.${window.location.hostname}` }, { // Regex matching cookie name. name: /^_ga/, domain: `.${window.location.hostname}` } ], language: { locale: { en: { name: 'Google Analytics' } } } }, yt: { category: 'various', type: 'dynamic-script', search: 'youtube', cookies: [ { // Known cookie name. name: 'YSC', // Expected cookie domain. domain: '.youtube.com' }, { // Known cookie name. name: 'VISITOR_INFO1_LIVE', // Expected cookie domain. domain: '.youtube.com' } ], language: { locale: { en: { name: 'Youtube' } } } }, pp: { category: 'various', type: 'dynamic-script', search: 'paypal', cookies: [ { // Regex matching cookie name. name: /^ts/, // Expected cookie domain. domain: '.paypal.com' } ], language: { locale: { en: { name: 'PayPal' } } } } } }); </script><style id="sccss"></style></head> <body class="page-template-default page page-id-10"> <div id="wrapper" class="hfeed"> <div id="header"> <div id="masthead"> <div id="branding" role="banner"> <div id="site-title"> <span> <a href="https://www.ozerov.de/bigdump/" rel="home">BigDump: Staggered MySQL Dump Importer</a> </span> </div> <div id="site-description"></div> <img src="https://www.ozerov.de/bigdump/files/2011/05/bigdump-header-web.jpg" width="940" height="198" alt="BigDump: Staggered MySQL Dump Importer" decoding="async" fetchpriority="high" /> </div> <div id="access" role="navigation"> <div class="skip-link screen-reader-text"><a href="#content">Skip to content</a></div> <div class="menu-header"><ul id="menu-menu-1" class="menu"><li id="menu-item-142" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-142"><a href="https://www.ozerov.de/bigdump/">Home</a></li> <li id="menu-item-143" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-143"><a href="https://www.ozerov.de/bigdump/you-want/">You want</a></li> <li id="menu-item-144" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-144"><a href="https://www.ozerov.de/bigdump/you-need/">You need</a></li> <li id="menu-item-145" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-10 current_page_item menu-item-145"><a href="https://www.ozerov.de/bigdump/usage/" aria-current="page">Usage</a></li> <li id="menu-item-146" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-146"><a href="https://www.ozerov.de/bigdump/faqs/">FAQs</a></li> <li id="menu-item-147" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-147"><a href="https://www.ozerov.de/bigdump/support/">Support</a></li> <li id="menu-item-148" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-148"><a href="https://www.ozerov.de/bigdump/version-history/">Version history</a></li> <li id="menu-item-149" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-149"><a href="https://www.ozerov.de/bigdump/android-kiosk/">Android Kiosk</a></li> <li id="menu-item-150" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-150"><a href="https://www.ozerov.de/bigdump/privacy/">Privacy</a></li> </ul></div> </div> </div> </div> <div id="main"> <div id="container"> <div id="content" role="main"> <div id="post-10" class="post-10 page type-page status-publish hentry"> <h1 class="entry-title">Usage</h1> <div class="entry-content"> <ol> <li>Download and unzip <em>bigdump.zip</em> on your PC.</li> <li>Open <em>bigdump.php</em> in a text editor, adjust the database configuration and dump file encoding.</li> <li>Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE” (use phpMyAdmin).</li> <li>Create the working directory (e.g. <em>dump</em>) on your web server</li> <li>Upload <em>bigdump.php</em> and the dump files (*.sql or *.gz) via FTP to the working directory (take care of <strong>TEXT</strong> mode upload for <em>bigdump.php</em> and <em>dump.sql</em> but <strong>BINARY</strong> mode for <em>dump.gz</em> if uploading from MS Windows).</li> <li>Run the <em>bigdump.php</em> from your web browser via URL like <em>http://www.yourdomain.com/dump/bigdump.php</em>.</li> <li>Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.</li> <li>BigDump will start every next import session automatically if JavaScript is enabled in your browser.</li> <li>Relax and wait for the script to finish. Do NOT close the browser window!</li> <li><strong>IMPORTANT:</strong> Remove <em>bigdump.php</em> and your dump files from your web server.</li> </ol> <h2>Advanced notes</h2> <p><strong>Note 1:</strong> BigDump will fail processing large tables containing extended inserts. An extended insert contains all table entries within one SQL query. BigDump isn’t able to split such SQL queries. In most cases BigDump will stop if some query includes to many lines. But if PHP complains that <em>allowed memory size exhausted</em> or <em>MySQL server has gone away</em> your dump probably also contains extended inserts. Please turn off extended inserts when exporting database from phpMyAdmin. If you only have a dump file with extended inserts please ask for our <a title="Support" href="http://www.ozerov.de/bigdump/support/">support service</a> in order to convert it into a file usable by BigDump.</p> <p><strong>Note 2:</strong> If you want to upload the dump files via web browser give the scripts writing permissions on the working directory (e.g. make chmod 777 on a Linux based system). You can upload the dump files from the browser up to the size limit set by the current PHP configuration of the web server. Alternatively you can upload any files via FTP. Some web servers disallow script execution in the directory with writing permissions for security reasons. If you changed the permissions on the working directory and you are getting a server error when running the script restore the permissions to their normal state (chmod 755) for directories.</p> <p><strong>Note 3:</strong> If Timeout errors still occur you may need to adjust the $linespersession setting in <em>bigdump.php</em>.</p> <p><strong>Note 4:</strong> If mySQL server overrun occurs due to max_requests restriction you can use $delaypersession setting to let the script sleep some milliseconds or more before starting next session. This setting will only work if the JavaScript is activated. Importing dump file on such servers may be very time consuming.</p> <p><strong>Note 5:</strong> BigDump is currently not able to restore a single dump file with multiple databases inside (switched by the USE statement). BigDump is also not able to restore a single specific database from the dump file containing multiple databases.</p> <p><strong>Note 6:</strong> If you experience problems with non-latin characters while using BigDump you have to adjust the $db_connection_char_set configuration variable in <em>bigdump.php</em> to match the encoding of your dump file.</p> <p><strong>Note 7:</strong> GZip support is only available with PHP 4.3.0 and later. Using a huge GZip compressed dump file can cause the script to exceed the PHP memory/runtime limit since the dump file has to be unpacked from the beginning every time the session starts. If this happens use the uncompressed dump. It’s your only chance.</p> <p><strong>Note 8:</strong> It’s not a very good idea, but if you can also import from CSV file into one mySQL table using Bigdump. You have to specify the table name in $csv_insert_table. Please also check other CSV settings in the Bigdump configuration.</p> </div> </div> <div id="comments"> </div> </div> </div> <div id="primary" class="widget-area" role="complementary"> <ul class="xoxo"> <li id="text-4" class="widget-container widget_text"><h3 class="widget-title">Download script</h3> <div class="textwidget"><br /> <a onclick="javascript:pageTracker._trackPageview('/bigdump.zip'); " href="https://www.ozerov.de/bigdump/files/2023/09/bigdump.zip">BigDump ver. 0.37b (beta)</a> <br />(12 KB ZIP archive)</div> </li><li id="text-3" class="widget-container widget_text"><h3 class="widget-title">Make Donation</h3> <div class="textwidget"> <br /> <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input name="cmd" type="hidden" value="_xclick" /> <input name="business" type="hidden" value="info@fully-kiosk.com" /> <input name="item_name" type="hidden" value="BigDump Donation" /> <input name="no_shipping" type="hidden" value="1" /> <input name="no_note" type="hidden" value="0" /> <input name="tax" type="hidden" value="0" /> <input name="currency_code" type="hidden" value="EUR" /> <input name="bn" type="hidden" value="PP-DonationsBF" /> <input name="lc" type="hidden" value="US" /> <input alt="Make payments with PayPal - it's fast, free and secure!" name="submit" src="https://www.paypal.com/en_US/i/btn/x-click-but04.gif" type="image" /> <img src="https://www.paypal.com/en_US/i/scr/pixel.gif" border="0" alt="" width="1" height="1" /> </form> <br /> <strong>Thank you!</strong> </div> </li> </ul> </div> </div> <div id="footer" role="contentinfo"> <div id="colophon"> <div id="site-info"> <a href="https://www.ozerov.de/bigdump/" rel="home"> BigDump: Staggered MySQL Dump Importer </a> </div> <div id="site-generator"> <a href="https://wordpress.org/" class="imprint" title="Semantic Personal Publishing Platform"> Proudly powered by WordPress. </a> </div> </div> </div> </div> <div id="closebutton"class="highslide-overlay closebutton"onclick="return hs.close(this)"title="Close"></div><a href="http://ucardo.com"title="The Smart QR Code on your Business Card"style="display:none">QR Code Business Card</a><script type="text/javascript"src="https://www.ozerov.de/bigdump/wp-content/plugins/highslide-4-wordpress-reloaded/highslide.min.js?ver=4113v128"></script><script type="text/javascript">hs.graphicsDir='https://www.ozerov.de/bigdump/wp-content/plugins/highslide-4-wordpress-reloaded/graphics/';hs.showCredits=true;hs.fadeInOut=false;hs.padToMinWidth=true;hs.outlineType='rounded-white';hs.registerOverlay({overlayId:'closebutton',position:'top right',fade:0});</script><script type="text/javascript" src="https://www.ozerov.de/bigdump/wp-includes/js/comment-reply.min.js?ver=6.7.2" id="comment-reply-js" async="async" data-wp-strategy="async"></script> </body> </html>