Add import POST parameters to URL in PHPMyAdmin

psytanium

• August 27, 2021 08:45

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 :

• 

  cPRex Jurassic Moderator

  • August 27, 2021 14:39

  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?

  0
• 

  psytanium

  • August 27, 2021 15:50

  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.

  0
• 

  cPRex Jurassic Moderator

  • August 27, 2021 16:02

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

  0
• 

  psytanium

  • August 27, 2021 16:44

  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 : or something like that.

  0
• 

  cPRex Jurassic Moderator

  • August 27, 2021 16:57

  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: 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.

  0
• 

  psytanium

  • August 27, 2021 17:01

  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: 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.

  0

Please sign in to leave a comment.