{"id":7690,"date":"2022-04-25T20:34:28","date_gmt":"2022-04-25T15:04:28","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=7690"},"modified":"2022-08-22T14:44:05","modified_gmt":"2022-08-22T09:14:05","slug":"mysql-dump-export-import","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-dump-export-import\/","title":{"rendered":"MySQL Dump Export \/ Import Using CUI\/GUI"},"content":{"rendered":"\n<p>MySQL Export, MySQL Dump Export, learn about mysqldump, Mysqldump outputs empty file using PHP exec, MySQL Import, MySQL Backup, MySQL Restore <\/p>\n\n\n\n<p>\u091c\u092c \u0939\u092e \u0915\u094b\u0908 \u092d\u0940 Database Project \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u091c\u092c \u0939\u092e\u0947 Database \u0915\u094b Local \u0938\u0947 Web \u092a\u0930 \u0936\u093f\u092b\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u092b\u093f\u0930 \u0939\u092e\u0947 \u092c\u0948\u0915\u0905\u092a \u0932\u0947 \u0915\u0930 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u0930\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e\u0947 MySQL Dump \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u0907\u0938 Command \u0938\u0947 \u0939\u092e \u092c\u0939\u0941\u0924 \u0939\u0940 \u0915\u092e \u0938\u092e\u092f \u092e\u0947 database \u0915\u093e Backup \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e GUI Graphical User Interface \u0914\u0930 CUI Command Line Interface \u0938\u0947 \u092c\u0948\u0915\u0905\u092a \u0932\u0947\u0928\u093e \u0914\u0930 \u0909\u0938\u0947 Restore \u0915\u0930\u0928\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<p><strong>\u0905\u092c \u0906\u092a\u0915\u0947 \u092e\u0928 \u092e\u0947 \u090f\u0915 \u0938\u0935\u093e\u0932 \u0906\u092f\u093e \u0939\u094b\u0917\u093e \u0915\u0940 \u091c\u092c GUI \u0938\u0947 \u0939\u0940 \u0915\u093e\u092e \u0939\u094b \u0930\u0939\u093e \u0939\u0948 \u0924\u094b \u0939\u092e Command line \u0938\u0947 \u0915\u094d\u092f\u0942 \u092e\u0947\u0939\u0928\u0924 \u0915\u0930\u0947 ? <\/strong>\u0907\u0938\u0915\u093e \u091c\u0935\u093e\u092c \u0939\u0948 \u0915\u0940 \u091c\u092c \u0906\u092a \u0905\u092a\u0928\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e\u090f \u0917\u090f \u0938\u0949\u092b\u094d\u091f\u0935\u0947\u092f\u0930 \u092e\u0947 \u092c\u0948\u0915\u0905\u092a \u0915\u093e Option \u0926\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b Command Line \u0938\u0947 backup \u0932\u0947\u0924\u0947 \u0906\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e Backup \u0914\u0930 Restore \u0938\u0947 Related \u0938\u092d\u0940 Point \u0938\u092e\u091d\u0947\u0902\u0917\u0947 \u091a\u0932\u093f\u090f \u0936\u0941\u0930\u0942 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>1. Backup Using Command Line (mysqldump) <\/li><li>2. Remove Definer Keyword from Exported SQL File<\/li><li>3. Restore Using Command Line (mysql)<\/li><li>4. PHP Script for Backup MySQL Data<\/li><li>5. Export Dump File in MySQL CPanel<\/li><li>6. Import Dump File in MySQL CPanel<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. Backup Using Command Line (mysqldump) <\/h2>\n\n\n\n<p>\u0907\u0938 \u0928\u093f\u092e\u094d\u0928 Command \u0938\u0947 \u0906\u092a Backup \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysqldump --host=&lt;HostName&gt; --user=&lt;UserName&gt; --password=&lt;Password&gt; --routines &lt;DatabaseName&gt; &gt; &lt;ExportFileName.sql&gt;\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0939 \u091c\u094b Path \u092f\u0902\u0939\u093e \u092a\u0930 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 \u092f\u0939 \u0906\u092a\u0915\u094b \u0905\u092a\u0928\u0947 \u0938\u093f\u0938\u094d\u091f\u092e \u092a\u0930 \u0926\u0947\u0916\u0928\u093e \u0939\u094b\u0917\u093e \u091c\u093f\u0938 Localtion \u092a\u0930 Wamp install \u0939\u0948\u0902 \u092f\u0939 \u0909\u0938\u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u094b\u0917\u093e D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysqldump<\/li><\/ul>\n\n\n\n<p>\u092e\u0947 \u0928\u0940\u091a\u0947 \u090f\u0915 Command \u0914\u0930 \u0932\u093f\u0916 \u0930\u0939\u093e \u0939\u0941 \u0907\u0938\u092e\u0947 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Command \u092e\u0947 \u091c\u094b Variable Pass \u0915\u093f\u090f \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 Value Put \u0915\u0940 \u0917\u0908 \u0939\u0948 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysqldump --host=localhost --user=root --password= --routines MyDatabase &gt; C:\\MySQL.sql\n<\/code><\/pre>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Command Execute \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u094b C:\\ Drive \u092e\u0947 \u0926\u0940 \u0917\u0908 Location \u092a\u0930 \u092b\u093e\u0907\u0932 \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u0940 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0939\u093e\u0901 \u092a\u0930 &#8211;routines \u0932\u093f\u0916\u0928\u0947 \u0938\u0947 database \u092e\u0947 \u092f\u0926\u093f \u0915\u094b\u0908 Function \u0914\u0930 Procedure \u0939\u0941\u0935\u0947 \u0924\u094b \u0935\u0939 \u092d\u0940 Export \u0939\u094b \u091c\u093e\u090f\u0902\u0917\u0947 \u0964 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. Remove Definer Keyword from Exported SQL File<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a Server \u0938\u0947 \u0915\u094b\u0908 Datbase Local \u092a\u0930 Import \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u092f\u093e \u092b\u093f\u0930 local \u0938\u0947 Server \u092a\u0930 \u0932\u0947 \u091c\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u092c \u0927\u094d\u092f\u093e\u0928 \u0930\u0916 \u0915\u0930 Exported File \u092e\u0947 \u0915\u0941\u091b \u092c\u0926\u0932\u093e\u0935 \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0964  \u092f\u0926\u093f \u0906\u092a \u0907\u0928 Keyword \u0915\u094b \u0939\u091f\u093e \u0926\u0947\u0902\u0917\u0947 \u0924\u094b Data Without Error Import \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.<strong>1. Remove Definer <\/strong>: Definer Keyword \u0915\u094b Remove \u0915\u0930\u0947 \u0964 <\/h3>\n\n\n\n<p><strong>\u092f\u0926\u093f \u0906\u092a\u0915\u0947 Database \u092e\u0947 \u0915\u094b\u0908 Function \u0914\u0930 Procedure \u092c\u0928\u0947 \u0939\u094b\u0902\u0917\u0947 \u0924\u092c \u0909\u0928\u0915\u0947 Syntax \u092e\u0947 \u0906\u092a\u0915\u094b Definer \u0932\u093f\u0916\u093e \u0939\u0941\u0906 \u092e\u093f\u0932\u0947\u0917\u093e \u0909\u0938\u0947 \u0906\u092a\u0915\u094b Remove \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Find Replace \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0906\u092a\u0915\u094b <em>DEFINER<\/em>&nbsp;= &#8216;admin&#8217;@&#8217;localhost&#8217;&nbsp;\u0915\u094b Remove \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><li>\u092f\u0939\u093e\u0901 \u092a\u0930 admin \u0915\u0940 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 root \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948 , \u092f\u093e localhost \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0915\u094b\u0908 IP \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0902 <\/li><li>\u0906\u092a\u0915\u094b File \u092e\u0947 <em>DEFINER<\/em> Search \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0914\u0930 <em>DEFINER<\/em>&nbsp;= &#8216;root&#8217;@&#8217;localhost&#8217; Remove \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.2. Replace <strong>DROP TRIGGER<\/strong> to <strong>DROP TRIGGER IF EXISTS<\/strong><\/h3>\n\n\n\n<p><strong>\u092f\u0926\u093f \u0906\u092a\u0915\u0947 Database \u092e\u0947 Trigger \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b Drop Trigger Syntax \u0915\u0947 \u0906\u0917\u0947 IF EXISTS \u091c\u094b\u095c\u0928\u093e \u0939\u094b\u0917\u093e \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 Import \u0915\u0930\u0924\u0947 \u0938\u092e\u092f Error \u0928\u0939\u0940\u0902 \u0906\u090f\u0917\u0940\u0964 <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092b\u093e\u0907\u0932 \u092e\u0947 \u091c\u0939\u093e \u092a\u0930 \u092d\u0940 <strong>DROP TRIGGER<\/strong> \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u094b <strong>DROP TRIGGER IF EXISTS<\/strong> \u0938\u0947 Replace \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. Restore Using Command Line (mysql) | MySQL Import Data <\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a Command Line \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u0940 \u0915\u093f\u0938\u0940 Blank Database \u092e\u0947 Data Import\/Restore \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b \u0928\u093f\u092e\u094d\u0928 Command \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysql --host=&lt;HostName&gt; --user=&lt;UserName&gt; --password=&lt;Password&gt; &lt;DatabaseName&gt; &lt; &lt;FileName.sql&gt;\n<\/code><\/pre>\n\n\n\n<p>\u0905\u092c \u0939\u092e \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Command \u092e\u0947 Value Put \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysql --host=localhost --user=root --password= MyDatabase &lt; C:\\MySQL.sql\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u091c\u094b \u0906\u092a\u0928\u0947 \u092a\u0939\u0932\u0947 Data Export \u0915\u093f\u092f\u093e \u0925\u093e \u0935\u0939 \u0926\u093f\u090f \u0917\u090f Database \u092e\u0947 Import \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964 <\/li><li>\u0927\u094d\u092f\u093e\u0928 \u0930\u0939\u0947 <strong>import \u0915\u0947 \u0938\u092e\u092f Blank Database <\/strong>\u0915\u093e \u0939\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947 \u0915\u094d\u092f\u0941\u0915\u0940 \u091c\u094b SQL Export File \u092e\u0947 \u0932\u093f\u0916\u0940 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 Drop Syntax \u0932\u093f\u0916\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u091c\u094b \u0906\u092a\u0915\u0947 Source Database \u092e\u0947 \u0924\u092c\u093e\u0939\u0940 \u092e\u091a\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. PHP Script for Backup MySQL Data<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a PHP \u0938\u094d\u0915\u094d\u0930\u093f\u092a\u094d\u091f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0905\u092a\u0928\u0947 database \u0915\u093e Backup \u0932\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a\u0915\u094b PHP exec \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u091c\u092c \u0906\u092a PHP exec \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b File \u0924\u094b \u092c\u0928\u0928\u0947 \u0932\u0917\u0924\u0940 \u0939\u0948\u0902 \u092a\u0930\u0902\u0924\u0941 File Blank \/ Empty \u092c\u0928\u0924\u0940 \u0939\u0948\u0902, \u0906\u0907\u090f \u0939\u092e \u0906\u092a\u0915\u094b Step by Step \u092c\u0924\u093e\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0906\u092a\u0915\u094b \u0907\u0938 problem \u0915\u093e Solution \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"command-pattern-different-in-linux-windows\">Command &amp; Pattern Different in Linux \/ Windows <\/h2>\n\n\n\n<p>\u0905\u0927\u093f\u0915\u0924\u0930 \u0939\u092e Internet \u0938\u0947 Problem \u0915\u094b Find \u0915\u0930 \u0909\u0938 \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0928\u093e \u0936\u0941\u0930\u0942 \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u091c\u092c\u0915\u093f \u0906\u092a\u0915\u094b \u092f\u0939 \u092d\u0940 \u0927\u094d\u092f\u093e\u0928 \u0930\u0916\u0928\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a Command Windows \u092e\u0947 Execute \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u092f\u093e \u092b\u093f\u0930 Linux \u0907\u0928 \u0926\u094b\u0928\u094b\u0902 \u092e\u0947 \u0932\u093f\u0916\u0928\u0947 \u092e\u0947 \u0915\u0941\u091b Changes \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Type <\/strong><\/td><td><strong>Linux <\/strong><\/td><td><strong>Windows<\/strong><\/td><\/tr><tr><td>Command <\/td><td>mysqldump<\/td><td>path\\mysqldump.exe <\/td><\/tr><tr><td>Host<\/td><td>-hlocalhost<\/td><td>&#8211;host=localhost<\/td><\/tr><tr><td>User<\/td><td>-uroot<\/td><td>&#8211;user=root<\/td><\/tr><tr><td>Password<\/td><td>-p<\/td><td>&#8211;password=<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a\u0928\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 Linux \u0914\u0930 windows \u092e\u0947 \u0915\u0941\u091b changes \u0906\u0924\u0947 \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0906\u092a\u0915\u094b Command \u0915\u094b \u0915\u0941\u091b \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u092c\u0926\u0932\u093e\u0935 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li><li>\u091c\u0948\u0938\u0947 \u0915\u0940 Linux \u092e\u0947 mysqldump \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939\u0940 Windows \u092e\u0947 mysqldump.exe  \u092a\u0942\u0930\u0947 path \u0915\u0947 \u0938\u093e\u0925 \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0909\u0938\u0940 \u0924\u0930\u0939 host \u0915\u0947 \u0932\u093f\u090f window \u092e\u0947 &#8211;host \u0914\u0930 Linux \u092e\u0947 -h \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0940 \u0924\u0930\u0939 user \u0914\u0930 password \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 \u0939\u092e\u0947 window \u0914\u0930 linux \u092e\u0947 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li><li>Linux \u092e\u0947 \u0939\u092e\u0947 -u \u0915\u0947 \u092c\u093e\u0926 \u0915\u094b\u0908 \u092d\u0940 Space \u0928\u0939\u0940\u0902 \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u0914\u0930 \u0938\u0940\u0927\u0947 \u0939\u0940 user , password, host \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><li>\u0906\u092a \u0928\u093f\u092e\u094d\u0928 Command \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 current path \u0926\u0947\u0916 \u0915\u0930 \u091c\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u094b Backup \u0932\u0947\u0928\u093e \u0939\u0948 \u0935\u0939 Path set \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0964 <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">echo dirname(__FILE__);<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u0906\u092a \u0928\u093f\u092e\u094d\u0928 Code \u0938\u0947 Backup \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Dump Export Using Windows Operating System <\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">&lt;?php\n\n\/\/echo dirname(__FILE__);\n\n$Host = 'localhost';\n$User = 'root';\n$Pass = '';\n$DB   = 'database-name';\n$BackupFile   = 'file2.sql';\n\n$ExeFile   = \"\\\"D:\\\\wamp64\\\\bin\\\\mysql\\\\mysql8.0.18\\\\bin\\\\mysqldump.exe\\\"\";\necho $BackupCmd = \"$ExeFile --host=$Host --user=$User --password=$Pass $DB &gt; $BackupFile\";\n\n$VarOut    = \"\";\n$VarReturn = \"\";\nexec($BackupCmd, $VarOut, $VarReturn);\nvar_dump($VarOut);\nvar_dump($VarReturn);\n\n?&gt;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5. How to Export Dump File in MySQL CPanel<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a MySQL Database \u0915\u093e Backup Fast Method \u0938\u0947 \u0932\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b \u0928\u093f\u092e\u094d\u0928 Steps Follow \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"198\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-6.png?resize=495%2C198&#038;ssl=1\" alt=\"MySQL Dump Export cPanel\" class=\"wp-image-7997\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-6.png?w=495&amp;ssl=1 495w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-6.png?resize=300%2C120&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-6.png?resize=150%2C60&amp;ssl=1 150w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>1. Open CPanel :<\/strong> \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 CPanel Login \u0915\u0930\u0947 \u0964 <\/li><li><strong>2. Click on Backup Icon :<\/strong> Login \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u092c\u0939\u0941\u0924 \u0938\u0947 option \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u0947 \u0939\u094b\u0902\u0917\u0947 \u0907\u0928\u092e\u0947 \u0938\u0947 \u0906\u092a Backup Icon \u092a\u0930 Click \u0915\u0930\u0947 \u0964 <\/li><li><strong>3. Scroll Down Go to Download a MySQL Database Backup :<\/strong> \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u092a\u0930 \u091c\u094b \u092a\u0947\u091c open \u0939\u094b\u0917\u093e \u0909\u0938 \u092a\u0930 \u0906\u092a\u0915\u094b Download a MySQL Database Backup \u092a\u0930 Click \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><li><strong>4. Click on Database and Save to Local Drive : <\/strong>Click \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0905\u092a\u0928\u0940 Local Drive \u092a\u0930 Database \u0915\u094b Save \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6. How to Import Dump File in MySQL CPanel<\/h2>\n\n\n\n<p>\u091c\u094b \u092d\u0940 \u0906\u092a\u0928\u0947 Dump Export \u092f\u093e Backup \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Database \u0915\u094b Export \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 \u0906\u092a Import \u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 Database \u092e\u0947 Import \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 Import \u0915\u0930\u0928\u0947 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a File \u0915\u094b Open \u0915\u0930 \u0915\u093f\u0938\u0940 \u092d\u0940 Text Editor \u092e\u0947 Find Replace \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Definer \u0915\u094b Remove \u0915\u0930 \u0932\u0947\u0935\u0947 Definer \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0907\u0938\u0940 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 Point No 2 \u092e\u0947 \u092c\u0924\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0906\u092a \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930 Read \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Import File On Server<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Definer \u0915\u094b Replace \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a File \u0915\u094b Import \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u092f\u0926\u093f \u092b\u093e\u0907\u0932 \u0915\u0940 \u0938\u093e\u0907\u095b \u092c\u095c\u0940 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a \u0909\u0938\u0947 Zip \u092c\u0928\u093e \u0915\u0930 Server \u092a\u0930 Upload \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964  <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"260\" height=\"292\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-7.png?resize=260%2C292&#038;ssl=1\" alt=\"MySQL Import CPanel\" class=\"wp-image-7999\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-7.png?w=260&amp;ssl=1 260w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/03\/image-7.png?resize=150%2C168&amp;ssl=1 150w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>1. Open CPanel : <\/strong>\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 CPanel Open \u0915\u0930\u0947 \u0964 <\/li><li><strong>2. Find phpMyAdmin :<\/strong> \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 List \u092e\u0947 \u0938\u0947 phpMyAdmin Icon Search \u0915\u0930 Open \u0915\u0930\u0947 \u0964 <\/li><li><strong>3. Select Database From List:<\/strong> \u092b\u092a\u094d\u092e\u094d\u092f\u0919\u094d\u092e\u093f\u0928 \u0913\u092a\u0928 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u094b \u0932\u0947\u092b\u094d\u091f \u0938\u093e\u0907\u0921 \u092e\u0947 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 \u0921\u093e\u091f\u093ebase \u0906\u092a\u0915\u0947 \u0938\u0930\u094d\u0935\u0930 \u092e\u0947 \u0939\u094b\u0902\u0917\u0947 \u0935\u0939 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0902\u0917\u0947 , \u091c\u093f\u0938 \u092d\u0940 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947 \u0906\u092a\u0915\u094b Data \u0907\u092e\u094d\u092a\u094b\u0930\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0905\u092c \u0906\u092a \u0909\u0938\u0947 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947 <strong>(\u0927\u094d\u092f\u093e\u0928 \u0930\u0939\u0947 \u0915\u0940 \u091c\u093f\u0938 \u092d\u0940 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947 \u0906\u092a \u0907\u092e\u094d\u092a\u094b\u0930\u094d\u091f \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0916\u093e\u0932\u0940 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f , \u0909\u0938\u092e\u0947 \u0915\u094b\u0908 table \u0906\u0926\u093f \u0928\u0939\u0940\u0902 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f)<\/strong><\/li><li><strong>4. Click on Import Tab :<\/strong> Database Select \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b Top \u092e\u0947 \u091c\u094b Tab List \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u0940 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u0938\u0947 Import Tab \u092a\u0930 Click \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><li><strong>5. Choose Database File :<\/strong> Import \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u094b Page Open \u0939\u094b\u0917\u093e \u0909\u0938\u092e\u0947 \u0906\u092a\u0915\u094b Choose Database File \u092a\u0930 Select \u0915\u0930 Database File \u091c\u094b \u0915\u0940 \u0906\u092a\u0928\u0947 Export \u0915\u0940 \u0925\u0940 \u0909\u0938\u0947 Select \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><li><strong>6. Click On Go Button :<\/strong> File Select \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b Go Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<p>\u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u0925\u094b\u095c\u0940 \u0926\u0947\u0930 \u092e\u0947 Database Import \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964 \u092f\u0926\u093f \u0915\u094b\u0908 Error \u0906\u0924\u0940 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a Error \u0915\u094b \u092a\u095d \u0915\u0930 Steps Follow \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e upload \u0915\u0940 \u0917\u0908 File \u0915\u0940 Size \u0906\u0927\u093f\u0915 \u0939\u094b \u0924\u094b \u0906\u092a \u0909\u0938\u0915\u0940 zip File \u092c\u0928\u093e \u0915\u0930 \u092d\u0940 upload \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>\u00a0<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f , \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926  <\/p>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1650897350754\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Q. Mysqldump outputs empty file using PHP exec<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>A.  \u091c\u092c Window \u0914\u0930 Linux \u0915\u0940 Command \u092e\u0947 \u0915\u0941\u091b \u0905\u0902\u0924\u0930 \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 Detail \u092e\u0947 \u0938\u092e\u091d\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0932\u093f\u0916\u093e \u0917\u092f\u093e Code Local Server \u092a\u0930 \u091a\u0932 \u0930\u0939\u093e \u0939\u0948\u0902 \u0914\u0930 Web \u092a\u0930 \u0928\u0939\u0940\u0902 \u091a\u0932 \u0930\u0939\u093e \u0939\u0948\u0902 \u0924\u094b \u0906\u092a\u0915\u094b &#8211;host \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 -h, &#8211;user \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 -u, &#8211;password \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 -p \u0906\u0926\u093f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1655819922802\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I export and import MySQL database?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p><strong>For Export <\/strong><br \/>D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysqldump &#8211;host=&lt;HostName&gt; &#8211;user=&lt;UserName&gt; &#8211;password=&lt;Password&gt; &#8211;routines &lt;DatabaseName&gt; &gt; &lt;ExportFileName.sql&gt;<br \/><strong>For Import <\/strong><br \/>D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysql &#8211;host=&lt;HostName&gt; &#8211;user=&lt;UserName&gt; &#8211;password=&lt;Password&gt; &lt;DatabaseName&gt; &lt; &lt;FileName.sql&gt;<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1655819936809\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">How do I export a MySQL database dump?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>\u0906\u092a \u0928\u093f\u092e\u094d\u0928 Command \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Database \u0915\u094b Export \/ Dump \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <br \/>D:\\wamp64\\bin\\mysql\\mysql8.0.18\\bin\\mysqldump &#8211;host=&lt;HostName&gt; &#8211;user=&lt;UserName&gt; &#8211;password=&lt;Password&gt; &#8211;routines &lt;DatabaseName&gt; &gt; &lt;ExportFileName.sql&gt;<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1655819966465\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">What is MySQL dump file?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Mysqldump \u090f\u0915 Utility \u091c\u093f\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0906\u092a MySQL Database \u0915\u093e Logical Backup \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 SQL Format \u092e\u0947 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b backup \u092b\u093e\u0907\u0932 \u092c\u0928\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0947 dump file \u092d\u0940 \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>MySQL Export, MySQL Dump Export, learn about mysqldump, Mysqldump outputs empty file using PHP exec, MySQL Import, MySQL Backup, MySQL Restore \u091c\u092c \u0939\u092e \u0915\u094b\u0908 \u092d\u0940 Database Project \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u091c\u092c \u0939\u092e\u0947 Database \u0915\u094b Local \u0938\u0947 Web \u092a\u0930 \u0936\u093f\u092b\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u092b\u093f\u0930 \u0939\u092e\u0947 \u092c\u0948\u0915\u0905\u092a \u0932\u0947 \u0915\u0930 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u0930\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e\u0947 MySQL Dump [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8278,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-7690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/04\/mysql-backup-restore.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/7690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=7690"}],"version-history":[{"count":71,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/7690\/revisions"}],"predecessor-version":[{"id":8713,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/7690\/revisions\/8713"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/8278"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=7690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=7690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=7690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}