SQL experience needed

Post by **Jeff-20** » Sat Feb 02, 2013 8:26 pm

Does anyone here feel experienced with MYSQL databases? We need another collaborator on the project to upgrade our forum software. Thanks!

Post by **joshuadenmark** » Sun Feb 03, 2013 2:15 am

Hi Jeff

I think we hit the limit for sql queries when trying to upload the database!

At my host (with the test forum) I use a program called Sypex Dumper 2 to upload the SQL, with great luck, this program doesen't even respond at your host.

If you can find at talented SQL guy to do the upload, I will provide a recent converted forum backup file (SQL)

Kind regards
Peter

From your host site:
MySQL connections and query limits

A query limit is the maximum number of database actions performed in one hour by a specific user. Note that a user can have multiple concurrent MySQL connections, in which case the sum of all database actions for all connections cannot exceed the given limit.

The maximum number of concurrent MySQL connections per user is 10.
The maximum number of database queries per user is 75,000/hr.

Dusty · Post by **Dusty** » Sun Feb 03, 2013 4:53 am

Well, I think, I am a little experienced with handling MySQL DBs, so feel free, if there is any specific problem I might help.

Many providers limit the execution time of PHP scripts to a limit of 60 or 120 seconds or so. When you try to access a large DB (downloading or uploading), programs like PHPMyAdmin are exceeding this limit and are stopped by the server.

If you have root access to your server, you could increase the execution time of PHP scripts by editing the "max_execution_time" variable in the PHP.INI file.

If not, you could use a program like MySQLDumper (works very stable) to work around this limit.[/url]

Post by **joshuadenmark** » Sun Feb 03, 2013 5:15 am

I am not familiar with MySQLDumper and can't take the risk of messing up the database. The updated forum uses the same database as this forum but with another prefix, so messing up is easy.

Let us hear what Jeff says, as I can provide the files needed to do a recent upgrade.

Can you perform the upload of the SQL Dusty?

Dusty · Post by **Dusty** » Sun Feb 03, 2013 8:00 am

Yes, with MySQlDumper it's easy to upload large DB files to a web DB server.

What is needed?
- FTP access to the website (to upload and install MySQLDumper).
- The MySQL dump from the current DB (as provided by PHPMyAdmin or similar)
- Access to the new DB

This should work. Did similar things several times in the past. If you have a test installation of the forum running somewhere, it shouldn't be a problem (okay, we all know, there might be unpredictable problems, though...

)

Post by **joshuadenmark** » Sun Feb 03, 2013 10:05 am

I've got unpredictable problems when trying to convert the forum on denial host, the SQL went off shutting down this forum too...

But lets give it a go anyway, I have plenty of backup's

Dusty · Post by **Dusty** » Sun Feb 03, 2013 10:32 am

I see, so the problem seems to be the MySQL server rather than executing the PHP script, right? But it DOES work on a local machine running XAMPP or so?

Post by **joshuadenmark** » Sun Feb 03, 2013 12:41 pm

I think it's the host limiting the sql connections.

When doing the same job at my online host (gigahost.dk) there is no problem at all getting the SQL database uploaded in just a few minutes using Sypex Dumper 2. But using this tool at Denial's host it can't connect at all.

Maby You can get more lucky doing the trick with MySQL dumper

Dusty · Post by **Dusty** » Sun Feb 03, 2013 5:33 pm

Let's give it a try!

Post by **joshuadenmark** » Wed Feb 06, 2013 10:08 am

Update will take place 17.Feb - keep fingers crossed

rhurst · Post by **rhurst** » Thu Feb 07, 2013 12:35 pm

The tension from this countdown feels a lot like this.

Post by **joshuadenmark** » Fri Feb 08, 2013 12:08 am

Mike · Post by **Mike** » Sun Feb 10, 2013 5:10 am

I also keep my fingers crossed. It's about time. In the 'International VIC' section a guest (Sedeinvenia) found a way to spam around.