Import Database too big

Questions about hosting a Website, using MySQL, PhP or MariaDB may be posted here.
Forum rules
1) This is a user forum for Synology users to share experience/help out each other: if you need direct assistance from the Synology technical support team, please use the following form:

https://account.synology.com/support/support_form.php?lang=enu



2) To avoid putting users' DiskStation at risk, please don't paste links to any patches provided by our Support team as we will systematically remove them. Our Support team will provide the correct patch for your DiskStation model.
pucelano7
I'm New!
I'm New!
Posts: 8
Joined: Sun Oct 21, 2012 4:09 am

Import Database too big

Postby pucelano7 » Wed Nov 15, 2017 12:52 am

Hi,

I have a web (phpbb3 forum) running in a server but now I'm trying to transfer it to my NAS.

I want to import the Database to phpMyAdmin in my NAS but when I try to do it, an error appears because the Database is too big (154 Mb).

I have done the next steps:
1.- I go to phpMyAdmin of "myOldDomain.com" and export the Database called "myOldDatabase" => I obtain a file called "myDataBase.sql" (150 Mb)
2.- I go to phpMyAdmin of my Synology NAS through "myNewDomain.com" and I create a new Database called "myNewDatabase".
3.- Then I select "myNewDatabase" and I import the "myDataBase.sql" file => It try to do it buf finally I have an error because "the Database is too big"
4.- Also I have tried to use "bigDump" application to solve it but the next error appears: "Database connection failed due to No such file or directory"

¿How I configure bigDump?
* I copy "bigdump.php" file and "myDataBase.sql" in "web\tmp" folder of the NAS
* I do some modifications in"bigdump.php" file:
-> // Database configuration
$db_server = 'localhost';
$db_name = 'myNewDatabase';
$db_username = 'username_of_new_database';
$db_password = 'password_of_new_database';

-> // OPTIONAL SETTINGS
$filename = 'myDataBase.sql'; // Specify the dump filename to suppress the file selection dialog

What do I have wrong?

Thanks!
Last edited by pucelano7 on Wed Nov 15, 2017 8:54 am, edited 1 time in total.
wyodor
Sharp
Sharp
Posts: 188
Joined: Sat May 11, 2013 1:21 pm

Re: Import Database too big

Postby wyodor » Wed Nov 15, 2017 8:43 am

Shouldn't you use myDataBase.sql as $filename?
pucelano7
I'm New!
I'm New!
Posts: 8
Joined: Sun Oct 21, 2012 4:09 am

Re: Import Database too big

Postby pucelano7 » Wed Nov 15, 2017 8:55 am

wyodor wrote:Shouldn't you use myDataBase.sql as $filename?


Yes, this is what I use. It was a mistake in my explanation of the problem, sorry! (I have corrected it, thanks)
User avatar
HarryPotter
Honorary Moderator
Honorary Moderator
Posts: 19267
Joined: Mon Oct 23, 2006 12:48 pm
Location: Switzerland

Re: Import Database too big

Postby HarryPotter » Wed Nov 15, 2017 12:30 pm

Check the ports. MariaDB5 is listening on default port 3306, MariaDB 10 on port 3307.
*Please do not Private Message me for support questions; leave it on the forum so all members can learn. Thanks!*

DS718+ / DSM 6.2-23511 / ST4000VN000-2AH166 / SA400S37120G SSD cache /16 GB RAM
DS415+ / DSM 6.2-23511

LMS 7.9.1-166, 2 Squeezebox 3 + Boom

APC Smart UPS SUA750i
pucelano7
I'm New!
I'm New!
Posts: 8
Joined: Sun Oct 21, 2012 4:09 am

Re: Import Database too big

Postby pucelano7 » Wed Nov 15, 2017 12:45 pm

HarryPotter wrote:Check the ports. MariaDB5 is listening on default port 3306, MariaDB 10 on port 3307.


Ok, I will check it

Thanks!
pucelano7
I'm New!
I'm New!
Posts: 8
Joined: Sun Oct 21, 2012 4:09 am

Re: Import Database too big

Postby pucelano7 » Sat Nov 18, 2017 7:58 pm

Finally I have found the problem!

I have to use the next configuration in 'bigdump.php':
-> // Database configuration
$db_server = 'localhost:3307';
$db_name = 'myNewDatabase';
$db_username = 'username_of_new_database';
$db_password = 'password_of_new_database';

As you can see is necessary write the port in $db_server: My Synology NAS use MariaDB10 and the port 3307.

Also, the User of $db_username and $db_password must have rights to access to the database of $db_name

I hope it would be useful to other persons with the same problem

Return to “Web Server + PHP / MySQL + MariaDB”

Who is online

Users browsing this forum: No registered users and 2 guests