{"id":456,"date":"2014-04-18T14:50:46","date_gmt":"2014-04-18T08:50:46","guid":{"rendered":"https:\/\/www.tanvirisraq.com\/?p=456"},"modified":"2019-10-24T15:26:01","modified_gmt":"2019-10-24T09:26:01","slug":"import-large-mysql-database","status":"publish","type":"post","link":"https:\/\/www.tanvirisraq.com\/bn\/import-large-mysql-database\/","title":{"rendered":"\u09ac\u09dc \u09ae\u09be\u0987\u09b8\u09bf\u0995\u09c1\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u0987\u09ae\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09be"},"content":{"rendered":"<p>Shared Hosting \u098f Limitation \u098f\u09b0 \u0995\u09be\u09b0\u09a3\u09c7 \u09ac\u09dc MySQL Database Import \u0995\u09b0\u09be \u09af\u09be\u09df \u09a8\u09be\u0964 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 \u0986\u09aa\u09a8\u09bf \u09af\u0996\u09a8 LocalHost \u09ac\u09be PC \u09a4\u09c7 Website \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7\u09a8, \u09b8\u09c7\u099f\u09be \u098f\u0995\u099f\u09be \u09ac\u09dc \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7\u0964 \u0986\u09aa\u09a8\u09bf \u09af\u0996\u09a8 \u098f\u0987 \u09b8\u09be\u0987\u099f\u099f\u09bf \u0985\u09a8\u09b2\u09be\u0987\u09a8\u09c7 \u09a8\u09bf\u09ac\u09c7\u09a8, \u0986\u09aa\u09a8\u09be\u0995\u09c7 \u098f\u0987 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09bf \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u0987\u09ae\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09a4\u09c7\u0987 \u09b9\u09ac\u09c7\u0964 \u09a4\u0996\u09a8 \u0986\u09aa\u09a8\u09bf \u099a\u09be\u0987\u09b2\u09c7 \u098f\u0987 \u099f\u09c1\u09b2\u099f\u09bf \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u099f\u09bf \u0987\u09ae\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8\u0964 \u099f\u09c1\u09b2\u099f\u09bf\u09b0 \u09a8\u09be\u09ae <a href=\"http:\/\/www.ozerov.de\/bigdump\" rel=\"nofollow noopener\" target=\"_blank\">BigDump : Staggered MySQL Dump Importer<\/a>. \u098f\u0987 Script \u099f\u09bf Dump \u0995\u09c3\u09a4 Database \u099f\u09bf\u09b0 \u0996\u09c1\u09ac \u099b\u09cb\u099f \u098f\u0995\u099f\u09be \u0985\u0982\u09b6 Import \u0995\u09b0\u09c7 \u098f\u09ac\u0982 \u09a8\u09bf\u099c\u09c7\u0995\u09c7 Restart \u0995\u09b0\u09c7\u0964 \u09a4\u09be\u09b0\u09aa\u09b0 \u0986\u09ac\u09be\u09b0 \u099a\u09be\u09b2\u09c1 \u09b9\u09df \u098f\u09ac\u0982 \u09a0\u09bf\u0995 \u09b8\u09c7\u0996\u09be\u09a8 \u09a5\u09c7\u0995\u09c7 Import \u0995\u09b0\u09be \u09b6\u09c1\u09b0\u09c1 \u0995\u09b0\u09c7, \u09af\u09c7\u0996\u09be\u09a8\u09c7 \u09aa\u09c2\u09b0\u09cd\u09ac\u09c7\u09b0 Session \u098f \u09b6\u09c7\u09b7 \u0995\u09b0\u09c7\u099b\u09bf\u09b2\u0964 \u0986\u09b0 \u098f \u09b8\u09ac \u0995\u09bf\u099b\u09c1\u0987 \u09b9\u09df Automatic \u09ad\u09be\u09ac\u09c7\u0964 \u09a8\u09bf\u099a\u09c7 \u098f\u099f\u09bf\u09b0 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0\u09ac\u09bf\u09a7\u09bf \u09a6\u09c7\u0993\u09df\u09be \u09b9\u09b2:<\/p>\n<ul>\n<li>\u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u0986\u09aa\u09a8\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09cb phpMyAdmin \u09ac\u09be \u0985\u09a8\u09cd\u09af \u0995\u09cb\u09a8 Database manager \u09a5\u09c7\u0995\u09c7 Database \u099f\u09bf Export \u09ac\u09be Dump \u0995\u09b0\u09c1\u09a8\u0964<\/li>\n<li>\u09af\u09c7\u0987 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u099f\u09bf Import \u0995\u09b0\u09ac\u09c7\u09a8, \u09b8\u09c7\u0996\u09be\u09a8\u09c7 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c1\u09a8\u0964<\/li>\n<li>BigDump Script \u099f\u09bf Dreamweaver \u09ac\u09be NotePad \u09ac\u09be \u0985\u09a8\u09cd\u09af \u0995\u09cb\u09a8 IDE \u09a6\u09bf\u09df\u09c7 Open \u0995\u09b0\u09c1\u09a8\u0964 \u09a8\u09bf\u099a\u09c7\u09b0 \u09b2\u09be\u0987\u09a8 \u0997\u09c1\u09b2\u09cb \u0996\u09c1\u0981\u099c\u09c7 \u09ac\u09c7\u09b0 \u0995\u09b0\u09c1\u09a8\u0964<\/li>\n<\/ul>\n<p><code>\/\/ Database configuration<\/code><\/p>\n<p><code>$db_server&nbsp;&nbsp; = 'localhost';<br \/>\n$db_name&nbsp;&nbsp;&nbsp;&nbsp; = '';<br \/>\n$db_username = '';<br \/>\n$db_password = '';<\/code><\/p>\n<p><code>\/\/ Connection charset should be the same as the dump file charset (utf8, latin1, cp1251, koi8r etc.)<br \/>\n\/\/ See http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/charset-charsets.html for the full list<br \/>\n\/\/ Change this if you have problems with non-latin letters<\/code><\/p>\n<p><code>$db_connection_charset = 'utf8';<\/code><\/p>\n<p><code>\/\/ OPTIONAL SETTINGS<\/code><\/p>\n<p><code>$filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = '';&nbsp;&nbsp;&nbsp;&nbsp; \/\/ Specify the dump filename to suppress the file selection dialog<br \/>\n$ajax&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = true;&nbsp;&nbsp; \/\/ AJAX mode: import will be done without refreshing the website<br \/>\n$linespersession&nbsp;&nbsp;&nbsp; = 3000;&nbsp;&nbsp; \/\/ Lines to be executed per one import session<br \/>\n$delaypersession&nbsp;&nbsp;&nbsp; = 0;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/\/ You can specify a sleep time in milliseconds after each session<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/\/ Works only if JavaScript is activated. Use to reduce server overrun<\/code><\/p>\n<ul>\n<li><code><code>$db_server = 'localhost';<\/code> \u098f\u09b0 \u099c\u09be\u09df\u0997\u09be\u09df \u0986\u09aa\u09a8\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 Host \u098f\u09b0 \u09a8\u09be\u09ae \u09a6\u09bf\u09a8\u0964 <code>$db_server = '123.45.678.9';<br \/>\n\t<code>$db_name = '';<\/code>\u098f\u09b0 \u099c\u09be\u09df\u0997\u09be\u09df \u0986\u09aa\u09a8\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u09c7\u09b0 \u09a8\u09be\u09ae \u09a6\u09bf\u09a8, \u09af\u09c7\u099f\u09bf \u0986\u09aa\u09a8\u09bf \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7\u099b\u09bf\u09b2\u09c7\u09a8\u0964 <code>$db_name = 'database_name';<br \/>\n\t<code>$db_username = '';<\/code>\u098f\u09b0 \u099c\u09be\u09df\u0997\u09be\u09df \u0986\u09aa\u09a8\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u09c7\u09b0 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0\u0995\u09be\u09b0\u09c0\/Username \u09a6\u09bf\u09a8\u0964 <code>$db_username = 'user';<br \/>\n\t<code>$db_password = '';<\/code>\u098f\u09b0 \u099c\u09be\u09df\u0997\u09be\u09df \u0986\u09aa\u09a8\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u09c7\u09b0 \u09aa\u09be\u09b8\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09a6\u09bf\u09a8\u0964 <code>$db_password = 'password';<br \/>\n\t<code>$filename = '';<\/code>\u098f\u09b0 \u099c\u09be\u09df\u0997\u09be\u09df \u0986\u09aa\u09a8\u09be\u09b0 Dump \u0995\u09b0\u09be \u09ab\u09be\u0987\u09b2\u09c7\u09b0 \u09a8\u09be\u09ae \u09a6\u09bf\u09a8\u0964 <code>$filename = 'dumped';<br \/>\n\t(\u09a8\u09cb\u099f: \u098f\u0996\u09be\u09a8\u09c7 Single ' Mark \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u09c7\u099b\u09c7\u0964)<\/code><\/code><\/code><\/code><\/code><\/code><\/li>\n<li><code>\u098f\u09ac\u09be\u09b0 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f\u09b0 Dump \u09ab\u09be\u0987\u09b2 \u0993 BigDump Script \u099f\u09bf \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u0986\u09aa\u09b2\u09cb\u09a1 \u0995\u09b0\u099c\u09be\u09df\u0964 \u09b2\u0995\u09cd\u09b7\u09cd\u09af \u09b0\u09be\u0996\u09c1\u09a8, \u09af\u09be\u09a4\u09c7 BigDump Script \u098f\u09ac\u0982 Dump \u0995\u09b0\u09be \u09ab\u09be\u0987\u09b2\u099f\u09bf \u098f\u0995\u0987 Directory \u09a4\u09c7 \u09a5\u09be\u0995\u09c7\u0964 (public_html \u098f\u09b0 \u09ad\u09c7\u09a4\u09b0 \u0986\u09aa\u09b2\u09cb\u09a1 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7, \u09af\u09be\u09a4\u09c7 Script \u099f\u09bf Browse \u0995\u09b0\u09be \u09af\u09be\u09df\u0964)<\/code><\/li>\n<li><code>BigDump Script \u099f\u09bf Browse \u0995\u09b0\u09c1\u09a8\u0964 Example: <code>http:\/\/example.net\/bigdump<\/code><\/code><\/li>\n<li><code>\u09a4\u09be\u09b0\u09aa\u09b0 \u0986\u09aa\u09a8\u09bf BigDump \u098f\u09b0 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6\u09a8\u09be \u09a6\u09c7\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8\u0964<\/code><\/li>\n<li><code>Start Import \u0995\u09cd\u09b2\u09bf\u0995 \u0995\u09b0\u09c1\u09a8\u0964<\/code><\/li>\n<li><code>\u09b6\u09c7\u09b7 \u09b9\u0993\u09df\u09be \u09aa\u09b0\u09cd\u09af\u09a8\u09cd\u09a4 \u0985\u09aa\u09c7\u0995\u09cd\u09b7\u09be \u0995\u09b0\u09c1\u09a8\u0964<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Shared Hosting \u098f Limitation \u098f\u09b0 \u0995\u09be\u09b0\u09a3\u09c7 \u09ac\u09dc MySQL Database Import \u0995\u09b0\u09be \u09af\u09be\u09df \u09a8\u09be\u0964 \u0995\u09bf\u09a8\u09cd\u09a4\u09c1 \u0986\u09aa\u09a8\u09bf \u09af\u0996\u09a8 LocalHost \u09ac\u09be PC \u09a4\u09c7 Website \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7\u09a8, \u09b8\u09c7\u099f\u09be \u098f\u0995\u099f\u09be \u09ac\u09dc \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7\u0964 \u0986\u09aa\u09a8\u09bf \u09af\u0996\u09a8 \u098f\u0987 \u09b8\u09be\u0987\u099f\u099f\u09bf \u0985\u09a8\u09b2\u09be\u0987\u09a8\u09c7 \u09a8\u09bf\u09ac\u09c7\u09a8, \u0986\u09aa\u09a8\u09be\u0995\u09c7 \u098f\u0987 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09bf \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u0987\u09ae\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09a4\u09c7\u0987 \u09b9\u09ac\u09c7\u0964 \u09a4\u0996\u09a8 \u0986\u09aa\u09a8\u09bf \u099a\u09be\u0987\u09b2\u09c7 \u098f\u0987 \u099f\u09c1\u09b2\u099f\u09bf \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u099f\u09bf \u0987\u09ae\u09aa\u09cb\u09b0\u09cd\u099f \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8\u0964 \u099f\u09c1\u09b2\u099f\u09bf\u09b0 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[42],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-technology"],"acf":[],"spectra_blocks_featured_image_url":null,"spectra_blocks_author_info":{"display_name":"Tanvir Israq","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/6eb558c15226736b7ffe9dd5d18831395c1a7d200559992b55756b52b7a31b6c?s=96&d=wavatar&r=g","author_link":"https:\/\/www.tanvirisraq.com\/bn\/author\/tanvirisraq\/","description":"Together, Better, Forever..."},"_links":{"self":[{"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":0,"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tanvirisraq.com\/bn\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}