export large database mysql phpmyadmin
up vote
11
down vote
favorite
I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)
Any idea how to solve this problem?!
Thanks :)
mysql phpmyadmin fatal-error
asked Nov 17 '13 at 8:50
ahajib
2,57794078
add a comment |
up vote
11
down vote
favorite
I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)
Any idea how to solve this problem?!
Thanks :)
mysql phpmyadmin fatal-error
asked Nov 17 '13 at 8:50
ahajib
2,57794078
add a comment |
up vote
11
down vote
favorite
up vote
11
down vote
favorite
I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)
Any idea how to solve this problem?!
Thanks :)
mysql phpmyadmin fatal-error
asked Nov 17 '13 at 8:50
ahajib
2,57794078
I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)
Any idea how to solve this problem?!
Thanks :)
mysql phpmyadmin fatal-error
mysql phpmyadmin fatal-error
asked Nov 17 '13 at 8:50
ahajib
2,57794078
asked Nov 17 '13 at 8:50
ahajib
2,57794078
edited Jun 27 '16 at 14:57
asked Nov 17 '13 at 8:50
ahajib
2,57794078
asked Nov 17 '13 at 8:50
ahajib
2,57794078
asked Nov 17 '13 at 8:50
ahajib
2,57794078
2,57794078
add a comment |
add a comment |
5 Answers
5
active
oldest
votes
up vote
12
down vote
accepted
I would suggest to try using the command line and the mysqldump.exe utility, as suggested here
answered Nov 17 '13 at 13:07
user2196728
1,94021014
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
add a comment |
up vote
11
down vote
If you are on a shared hosting or you don't have access to shell, then use mysqldumper script; copy it to your server and start it in your browser under "yourDomain.com/path_to_mysqlumper/"
MySQLDumper is a PHP and Perl based tool for backing up MySQL
databases. You can easily dump your data into a backup file and - if
needed - restore it. It is especially suited for shared hosting
webspaces, where you don't have shell access.
If you have shell access to your host servers (if provided by your host since not all shared server hosters give this access) then you may use SSH access like in this tutorial using Putty that you install and configure then import or export your databases like in this third tutorial.
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
add a comment |
up vote
9
down vote
If you have shared hosting and you are using GoDaddy Cpanel than they are providing you option to backup your database in following section.
Files => Backup => Download a MySQL Database Backup.
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
add a comment |
up vote
1
down vote
MySQLDumper worked like a charm for me at my hosted website. I had to copy one database and "paste" it into a new database. In MySQLDumper, it isn't apparent right away how to do this, but the key is to create a new configuration file in MySQLDumper and that will allow you to copy/restore to different databases.
On the home screen in MySQLDumper, click Configuration, then Configuration Files. There is a text box at the top allowing you to create a new Configuration file. In there, put in the information for the second database you need (you created a connection to the first database when you install MySQLDumper). Save it. Then you can click Restore where you can select the dump of the first database and restore it in the second one.
This was a lifesaver. Thanks!
answered Apr 22 '14 at 18:08
tom
111
add a comment |
up vote
0
down vote
increase
max_post_size
variable in php.ini file. Then you will be able to download it.
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
add a comment |
5 Answers
5
active
oldest
votes
5 Answers
5
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
12
down vote
accepted
I would suggest to try using the command line and the mysqldump.exe utility, as suggested here
answered Nov 17 '13 at 13:07
user2196728
1,94021014
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
add a comment |
up vote
12
down vote
accepted
I would suggest to try using the command line and the mysqldump.exe utility, as suggested here
answered Nov 17 '13 at 13:07
user2196728
1,94021014
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
add a comment |
up vote
12
down vote
accepted
up vote
12
down vote
accepted
I would suggest to try using the command line and the mysqldump.exe utility, as suggested here
answered Nov 17 '13 at 13:07
user2196728
1,94021014
I would suggest to try using the command line and the mysqldump.exe utility, as suggested here
answered Nov 17 '13 at 13:07
user2196728
1,94021014
answered Nov 17 '13 at 13:07
user2196728
1,94021014
answered Nov 17 '13 at 13:07
user2196728
1,94021014
answered Nov 17 '13 at 13:07
user2196728
1,94021014
1,94021014
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
add a comment |
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
1
1
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
Thanks for your answer. That's what I did to solve my problem.
– ahajib
Nov 17 '13 at 22:02
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
you're welcome, i'm happy to help ! phpmyadmin is a usefull tool ans makes many things simpler to administrate a Mysql DB, but it has its limitations... Cheers
– user2196728
Nov 17 '13 at 22:39
add a comment |
up vote
11
down vote
If you are on a shared hosting or you don't have access to shell, then use mysqldumper script; copy it to your server and start it in your browser under "yourDomain.com/path_to_mysqlumper/"
MySQLDumper is a PHP and Perl based tool for backing up MySQL
databases. You can easily dump your data into a backup file and - if
needed - restore it. It is especially suited for shared hosting
webspaces, where you don't have shell access.
If you have shell access to your host servers (if provided by your host since not all shared server hosters give this access) then you may use SSH access like in this tutorial using Putty that you install and configure then import or export your databases like in this third tutorial.
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
add a comment |
up vote
11
down vote
If you are on a shared hosting or you don't have access to shell, then use mysqldumper script; copy it to your server and start it in your browser under "yourDomain.com/path_to_mysqlumper/"
MySQLDumper is a PHP and Perl based tool for backing up MySQL
databases. You can easily dump your data into a backup file and - if
needed - restore it. It is especially suited for shared hosting
webspaces, where you don't have shell access.
If you have shell access to your host servers (if provided by your host since not all shared server hosters give this access) then you may use SSH access like in this tutorial using Putty that you install and configure then import or export your databases like in this third tutorial.
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
add a comment |
up vote
11
down vote
up vote
11
down vote
If you are on a shared hosting or you don't have access to shell, then use mysqldumper script; copy it to your server and start it in your browser under "yourDomain.com/path_to_mysqlumper/"
MySQLDumper is a PHP and Perl based tool for backing up MySQL
databases. You can easily dump your data into a backup file and - if
needed - restore it. It is especially suited for shared hosting
webspaces, where you don't have shell access.
If you have shell access to your host servers (if provided by your host since not all shared server hosters give this access) then you may use SSH access like in this tutorial using Putty that you install and configure then import or export your databases like in this third tutorial.
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
If you are on a shared hosting or you don't have access to shell, then use mysqldumper script; copy it to your server and start it in your browser under "yourDomain.com/path_to_mysqlumper/"
MySQLDumper is a PHP and Perl based tool for backing up MySQL
databases. You can easily dump your data into a backup file and - if
needed - restore it. It is especially suited for shared hosting
webspaces, where you don't have shell access.
If you have shell access to your host servers (if provided by your host since not all shared server hosters give this access) then you may use SSH access like in this tutorial using Putty that you install and configure then import or export your databases like in this third tutorial.
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
edited Jan 5 '14 at 20:42
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
answered Jan 5 '14 at 14:59
numediaweb
8,59685077
8,59685077
add a comment |
add a comment |
up vote
9
down vote
If you have shared hosting and you are using GoDaddy Cpanel than they are providing you option to backup your database in following section.
Files => Backup => Download a MySQL Database Backup.
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
add a comment |
up vote
9
down vote
If you have shared hosting and you are using GoDaddy Cpanel than they are providing you option to backup your database in following section.
Files => Backup => Download a MySQL Database Backup.
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
add a comment |
up vote
9
down vote
up vote
9
down vote
If you have shared hosting and you are using GoDaddy Cpanel than they are providing you option to backup your database in following section.
Files => Backup => Download a MySQL Database Backup.
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
If you have shared hosting and you are using GoDaddy Cpanel than they are providing you option to backup your database in following section.
Files => Backup => Download a MySQL Database Backup.
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
answered Aug 29 '15 at 8:40
Indrasinh Bihola
1,79731722
1,79731722
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
add a comment |
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
1
1
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
easy solution, works fine on name.com hosting.
– Wajdy Essam
Dec 27 '15 at 23:27
add a comment |
up vote
1
down vote
MySQLDumper worked like a charm for me at my hosted website. I had to copy one database and "paste" it into a new database. In MySQLDumper, it isn't apparent right away how to do this, but the key is to create a new configuration file in MySQLDumper and that will allow you to copy/restore to different databases.
On the home screen in MySQLDumper, click Configuration, then Configuration Files. There is a text box at the top allowing you to create a new Configuration file. In there, put in the information for the second database you need (you created a connection to the first database when you install MySQLDumper). Save it. Then you can click Restore where you can select the dump of the first database and restore it in the second one.
This was a lifesaver. Thanks!
answered Apr 22 '14 at 18:08
tom
111
add a comment |
up vote
1
down vote
MySQLDumper worked like a charm for me at my hosted website. I had to copy one database and "paste" it into a new database. In MySQLDumper, it isn't apparent right away how to do this, but the key is to create a new configuration file in MySQLDumper and that will allow you to copy/restore to different databases.
On the home screen in MySQLDumper, click Configuration, then Configuration Files. There is a text box at the top allowing you to create a new Configuration file. In there, put in the information for the second database you need (you created a connection to the first database when you install MySQLDumper). Save it. Then you can click Restore where you can select the dump of the first database and restore it in the second one.
This was a lifesaver. Thanks!
answered Apr 22 '14 at 18:08
tom
111
add a comment |
up vote
1
down vote
up vote
1
down vote
MySQLDumper worked like a charm for me at my hosted website. I had to copy one database and "paste" it into a new database. In MySQLDumper, it isn't apparent right away how to do this, but the key is to create a new configuration file in MySQLDumper and that will allow you to copy/restore to different databases.
On the home screen in MySQLDumper, click Configuration, then Configuration Files. There is a text box at the top allowing you to create a new Configuration file. In there, put in the information for the second database you need (you created a connection to the first database when you install MySQLDumper). Save it. Then you can click Restore where you can select the dump of the first database and restore it in the second one.
This was a lifesaver. Thanks!
answered Apr 22 '14 at 18:08
tom
111
MySQLDumper worked like a charm for me at my hosted website. I had to copy one database and "paste" it into a new database. In MySQLDumper, it isn't apparent right away how to do this, but the key is to create a new configuration file in MySQLDumper and that will allow you to copy/restore to different databases.
On the home screen in MySQLDumper, click Configuration, then Configuration Files. There is a text box at the top allowing you to create a new Configuration file. In there, put in the information for the second database you need (you created a connection to the first database when you install MySQLDumper). Save it. Then you can click Restore where you can select the dump of the first database and restore it in the second one.
This was a lifesaver. Thanks!
answered Apr 22 '14 at 18:08
tom
111
answered Apr 22 '14 at 18:08
tom
111
answered Apr 22 '14 at 18:08
tom
111
answered Apr 22 '14 at 18:08
tom
111
111
add a comment |
add a comment |
up vote
0
down vote
increase
max_post_size
variable in php.ini file. Then you will be able to download it.
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
add a comment |
up vote
0
down vote
increase
max_post_size
variable in php.ini file. Then you will be able to download it.
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
add a comment |
up vote
0
down vote
up vote
0
down vote
increase
max_post_size
variable in php.ini file. Then you will be able to download it.
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
increase
max_post_size
variable in php.ini file. Then you will be able to download it.
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
answered Oct 16 '15 at 5:29
Jitendra Pawar
6711017
6711017
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
add a comment |
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
I tried it & its working like charm for me
– Jitendra Pawar
Oct 16 '15 at 7:02
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f20028898%2fexport-large-database-mysql-phpmyadmin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
