Thread: running a batch script
I am trying to test out a package called phpGrid and I need to run through its tutorial. But there are some "kinks". I am developing on my ubuntu laptop in a docker container. The postgresql I need to test-to is AWS RDS Postgresql. I have an account and Server and can access it with pgAdmin. The install instructs for phpGrid asked me to modify conf.php. In my case I used app.conf which sets up the virtual host. I restarted the containers. Next the tutorial wants me to "run" an sql batch script to create the table. The batch script is pretty mySQL centric. I am attaching it.
Can I run this from pgAdmin the same way I would with phpMyAdmin in mySQL? Do I need to modify the script for postgresql? Is this the easiest way to create this sample table? I have one table that I have created in pgAdmin called called imagesdatabase and I'd prefer not to break that since it took some time with AWS support to get that going.
Attachment
Hi, > On 19. Jun, 2020, at 17:30, Richard Bernstein <richb201@gmail.com> wrote: > <mysql_db.sql> thanks for posting all private data to a public list! Can some list admin please delete at least the attached script? It contains lots of private data. No wonder, there are millions and millions of leaked personal information records on the net if, to put it mildly, some naivepeople post them publicly. Not even a slight hack into some site is needed to get such things these days. What a world. :-( Cheers, Paul
You're welcome. It is not real data: It was just a sample.
On Fri, Jun 19, 2020 at 12:08 PM Paul Förster <paul.foerster@gmail.com> wrote:
Hi,
> On 19. Jun, 2020, at 17:30, Richard Bernstein <richb201@gmail.com> wrote:
> <mysql_db.sql>
thanks for posting all private data to a public list!
Can some list admin please delete at least the attached script? It contains lots of private data.
No wonder, there are millions and millions of leaked personal information records on the net if, to put it mildly, some naive people post them publicly. Not even a slight hack into some site is needed to get such things these days.
What a world. :-(
Cheers,
Paul
On 6/19/20 8:30 AM, Richard Bernstein wrote: > I am trying to test out a package called phpGrid and I need to run > through its tutorial. But there are some "kinks". I am developing on my > ubuntu laptop in a docker container. The postgresql I need to test-to is > AWS RDS Postgresql. I have an account and Server and can access it with > pgAdmin. The install instructs for phpGrid asked me to modify conf.php. > In my case I used app.conf which sets up the virtual host. I restarted > the containers. Next the tutorial wants me to "run" an sql batch script > to create the table. The batch script is pretty mySQL centric. I am > attaching it. > > Can I run this from pgAdmin the same way I would with phpMyAdmin in > mySQL? Do I need to modify the script for postgresql? Is this the Yes. This script is definitely MySQL specific. Some examples: USE `sampledb`; CREATE TABLE `changes` ( `n_r` int(11) NOT NULL AUTO_INCREMENT, <--That would be SERIAL or IDENTITY. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; <--No go. UNLOCK TABLES; and so on. > easiest way to create this sample table? I have one table that I have Take a look at: https://pgloader.readthedocs.io/en/latest/ref/mysql.html > created in pgAdmin called called imagesdatabase and I'd prefer not to > break that since it took some time with AWS support to get that going. -- Adrian Klaver adrian.klaver@aklaver.com