help needed Apache and ySQL ! anyone !?

[satanizer]

Hi all,
I am facing problems in uploading an sql file within phpMyAdmin..
its size is around 2 MBs, and whenever I finish upload, i got the problem of timed out server or showing secure and nonsecure

components.. so its a timeout thing !
I checked with phpMyAdmin help, and it seems I need to change
the : max_file_size in php.ini in Apache... !
I couldnt locate the file ! where can I find it?
and do you know a better way of uploading the data into the data base?
I am a rookie , and I appreciate any help you would provide !
Cheers

 

[semiautomatix]

You using Windows or Linux (which flavour - I know Ubuntu is a bit different)?

 

[satanizer]

well, it's Linux, Fedora

 

[wab512]

php.ini should be located in /etc or /etc/php or /etc/php5

 

[bullfrog]

Quite easy. Take the sql back up file and split up the queries in it into a few smaller parts. Then instead of using the import thing to upload the file, copy and paste those split up parts into the text field under the SQL heading.

The back up file is just a bunch of queries that you run on the server so it can be run from that query field as well by pasting in the queries. The parts that you upload now are also smaller and should go quicker which should prevent the server from timing out

Another thing that you could try is to zip the back up file when using the import function. Most servers should be able to detect and unzip the now smaller file. This should stop the timeout too, if it's happening during the uploading!

 

[Nod]

Create a file with the contents:

<? phpinfo(); ?>

This will give you the location of the php.ini file.

The quickest way of loading the sql file is by logging into the system (ssh), getting the file over by scp, and then running it in via cli.

mysql *database* < *sql file* // If database exist

 

[satanizer]

Quite easy. Take the sql back up file and split up the queries in it into a few smaller parts. Then instead of using the import thing to upload the file, copy and paste those split up parts into the text field under the SQL heading.

The back up file is just a bunch of queries that you run on the server so it can be run from that query field as well by pasting in the queries. The parts that you upload now are also smaller and should go quicker which should prevent the server from timing out

Another thing that you could try is to zip the back up file when using the import function. Most servers should be able to detect and unzip the now smaller file. This should stop the timeout too, if it's happening during the uploading!

Hi
thanls for the info,
how can I split it that I do not have local server installed... ?
in all cases I need to upload it and then split it according to the queries....
can I use the notepad to do it?

 

[bullfrog]

You basically open the sql back up file in notepad. The files can differ slightly, so you'll have to check through yourself and see where and how to split it up.

Open file in notepad. Go to SQL part in phpmyadmin. Copy parts of the code from the notepad file and paste it in the query window, and click submit. You can split the file in about 4 sections in this way of copying and pasting. Also split the file in the blocks as they are.

--
-- Table structure for table `hcl_polling`
--

*above is commented out by the --, so its not that important. This would be where to the split the file. As long as you don't break up whats inside the block below!

DROP TABLE IF EXISTS `hcl_polling`;
CREATE TABLE `hcl_polling` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`assignid` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hcl_polling`
--

This should do exactly what the backup function would have done if it didn't time out.

 

[semiautomatix]

Quite easy. Take the sql back up file and split up the queries in it into a few smaller parts. Then instead of using the import thing to upload the file, copy and paste those split up parts into the text field under the SQL heading.

The back up file is just a bunch of queries that you run on the server so it can be run from that query field as well by pasting in the queries. The parts that you upload now are also smaller and should go quicker which should prevent the server from timing out

Another thing that you could try is to zip the back up file when using the import function. Most servers should be able to detect and unzip the now smaller file. This should stop the timeout too, if it's happening during the uploading!

Good point... its what I do when I don't have access to the php.ini file

 

[asmith]

If you have remote access to mysql you could download SqlYog comunity edition and try that instead of a web browser. That way you wont be affected by php/apache/browser timeouts.

Otherwise upload the sql file onto your server and from command line type

mysql -u myusername -p mydatabasename <mysqlfile.sql