Add import POST parameters to URL in PHPMyAdmin

[psytanium]

Hello,

I'm trying to schedule auto import of database using Crontab browser addon.
Is there a way to add the submit parameters to the URL ? so i will have something like this :

http://localhost/phpmyadmin/db_import.php?db=catalog&import_file=db_catalog&import_type=sql&etc

...

When I submit the URL, the import process run the same like I was filling it manually.

Thanks for any ideas

 

[cPRex]

Hey there! If I'm reading the docs correctly, the cronTab browser addon just opens a URL at a scheduled time. If you wanted it to work with PHPMyAdmin, you'd have to ensure the link you're using is an authenticated session, but the browser session ID changes each time you access WHM or cPanel, so I'm not sure that is going to be a good option.

Is there any way you could setup a normal cron on the server to perform this work instead with MySQL commands?

 

[psytanium]

Hey there! If I'm reading the docs correctly, the cronTab browser addon just opens a URL at a scheduled time. If you wanted it to work with PHPMyAdmin, you'd have to ensure the link you're using is an authenticated session, but the browser session ID changes each time you access WHM or cPanel, so I'm not sure that is going to be a good option.

Is there any way you could setup a normal cron on the server to perform this work instead with MySQL commands?

The problem is I'm working locally using Wampserver, thants why I can't use CronJob.

 

[cPRex]

Thanks for that information. Is there a specific error happening when using the URL?

 

[psytanium]

I don't know what URL I should use, if I open PHPMyAdmin, then select the database, then click on Import, this is the URL I get :

http://localhost/phpmyadmin/db_import.php?db=catalog

From there I manually choose and upload a SQL file, then click submit. What I'm trying to do, is add some parameters to the URL to avoid manually adding the file and submitting the form.

For example: http://localhost/phpmyadmin/db_import.php?db=catalog&file_upload=my_data.sql or something like that.

 

[cPRex]

I don't believe there is going to be a way to do that through a URL-based system. When I access PHPMyAdmin from cPanel, I get the following URL:

https://x.x.x.x:2083/cpsess0123456789/3rdparty/phpMyAdmin/index.php

Through WHM, I get this URL:

https://x.x.x.x.:2087/cpsess0123456789/3rdparty/phpMyAdmin/index.php

Without that session code, which changes with each log in, it's not going to properly execute and let you access the page. With the URLs you provided, it sounds like you might actually have an external installation of PHPMyAdmin on the machine, but even that saves the individual authentication session elsewhere, so a URL wouldn't work there either.

I'd look toward a different solution to try and automate this.

 

[psytanium]

I don't believe there is going to be a way to do that through a URL-based system. When I access PHPMyAdmin from cPanel, I get the following URL:

https://x.x.x.x:2083/cpsess0123456789/3rdparty/phpMyAdmin/index.php

Through WHM, I get this URL:

https://x.x.x.x.:2087/cpsess0123456789/3rdparty/phpMyAdmin/index.php

Without that session code, which changes with each log in, it's not going to properly execute and let you access the page. With the URLs you provided, it sounds like you might actually have an external installation of PHPMyAdmin on the machine, but even that saves the individual authentication session elsewhere, so a URL wouldn't work there either.

I'd look toward a different solution to try and automate this.

Yes PHPMyAdmin comes with Wampserver, so it's installed on my machine, testing environment. But anyway, thanks for reading my post.