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.
Attachments:
mysql_db.sqlapplication/sql; name=mysql_db.sqlDownload
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
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:
Show quoted text
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