Обсуждение: running a batch script

Поиск
Список
Период
Сортировка

running a batch script

От
Richard Bernstein
Дата:
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. 
Вложения

Re: running a batch script

От
Paul Förster
Дата:
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


Re: running a batch script

От
Richard Bernstein
Дата:
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

Re: running a batch script

От
Adrian Klaver
Дата:
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