Re: Switching Database Engines

On 04/26/11 12:24 PM, Carlos Mennens wrote:
>
> I tried running the tool as suggested before and unless I'm doing
> something wrong, I have no idea why it didn't work:
>
> [root@db_old postgres]# pwd
> /var/www/html/int/main/wiki/maintenance/postgres
>
> [root@db_old postgres]# ls -l
> total 60
> drwxr-xr-x 2 root root  4096 Jul 13  2009 archives
> -rw-r--r-- 1 root root 13988 Mar 12  2009 compare_schemas.pl
> -rw-r--r-- 1 root root 14063 Nov 22  2008 mediawiki_mysql2postgres.pl
> -rw-r--r-- 1 root root 23596 Mar 19  2009 tables.sql
>
> [root@db_old postgres]# sh mediawiki_mysql2postgres.pl
> mediawiki_mysql2postgres.pl: line 12: use: command not found
> mediawiki_mysql2postgres.pl: line 13: use: command not found
> mediawiki_mysql2postgres.pl: line 14: use: command not found
> mediawiki_mysql2postgres.pl: line 15: use: command not found
> mediawiki_mysql2postgres.pl: line 17: syntax error near unexpected token `('
> mediawiki_mysql2postgres.pl: line 17: `use vars qw(%table %tz %special
> @torder $COM);'

wild guess says, use perl, not sh to run a .pl