主页 / user-4268

maniat1k's questions

Martin Hope
maniat1k
Asked: 2012-10-25 11:10:18 +0800 CST
  • 8

无法在 上创建临时文件/var/tmp。

mysqldump: Error: 'Can't create/write to file '/var/tmp/mysql.k6NKGk/#sql_5dc_2.MAI' (Errcode: 2)' when trying to dump tablespaces

在我的操作系统上。

 id mysql
uid=60(mysql) gid=105(mysql) groups=105(mysql)

ls -l /var/
drwxrwxrwt  2 root root  72 oct 24 16:43 tmp

我能做些什么？

mysql backup
Martin Hope
maniat1k
Asked: 2012-10-20 06:27:56 +0800 CST
  • 3
GRANT ALL ON my-database.* TO [email protected] IDENTIFIED BY 'password';
ERROR 1046 (3D000): No database selected

好的，我创建了一个名称上带有“-”的数据库（对用户做了同样的事情）......然后当我尝试对其设置授权时，数据库将无法工作。

如果我使用基地，错误是不同的

MariaDB [(none)]> use my-base
Database changed
MariaDB [my-base]> GRANT ALL ON 'my-base'.* TO 'my-user'@'10.0.0.1' IDENTIFIED BY 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''my-base'.* TO 'my-user'@'10.0.0.1' IDENTIFIED BY 'password'' at line 1
MariaDB [my-base]>
mariadb
Martin Hope
maniat1k
Asked: 2012-04-26 05:17:08 +0800 CST
  • 3

任何人都可以告诉我该怎么做？

（我知道这可能是一个愚蠢的问题，但我正在尝试学习如何使用 postgresql 的命令行）

~$ psql mybase
psql (9.1.3)
Type "help" for help.

接着

mybase=# \dt



            List of relations
 Schema |        Name         | Type  |  Owner   
--------+---------------------+-------+----------
 public | xxxxxx              | table | postgres
 public | xxxxxxx             | table | postgres
 public | xxxxxxxxxxx         | table | postgres
 public | xxxxxxxx            | table | postgres
 public | xxxxxxxxx           | table | postgres
 public | xxxxxxxxx           | table | postgres
 public | xxxxxxxxxxxxxxxx    | table | postgres
 public | xxxxxxxxxxxx        | table | postgres
 public | xxxxxxxxxxxxxxxx    | table | postgres
 public | xxxxxxxxxx          | table | postgres
 public | xxxxxxxxx           | table | postgres
 public | xxxxxxxxxxxxxxxx    | table | postgres
 public | xxxxxxxx            | table | postgres

只想要一张桌子然后做一个恢复=D谢谢

postgresql
Martin Hope
maniat1k
Asked: 2012-04-25 06:07:48 +0800 CST
  • 1

看看这个：

> cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
umask 022
#DISPLAY=:0.0
#export DISPLAY
TMP=/tmp
TMPDIR=/tmp

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_HOME

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/usr/local/bin
export PATH

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

ORACLE_SID=SSAE
export ORACLE_SID

看起来像工作

~ # service dbora status

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 24-APR-2012 10:01:40

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date                09-APR-2012 13:19:59
Uptime                    14 days 20 hr. 41 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=t2libora1)(PORT=1521)))
Services Summary...
Service "xxxx" has 1 instance(s).
  Instance "xxxx", status READY, has 1 handler(s) for this service...
Service "xxxxDB" has 1 instance(s).
  Instance "xxxx", status READY, has 1 handler(s) for this service...
Service "xxxx_XPT" has 1 instance(s).
  Instance "xxxx", status READY, has 1 handler(s) for this service...
The command completed successfully

但无法连接

:~ # su oracle
>  sqlplus / as sysdba
bash: sqlplus: no se encontró la orden

我不是甲骨文的人......我很感激任何帮助......（对不起我的英语）

oracle sqlplus
Martin Hope
maniat1k
Asked: 2011-12-28 06:47:16 +0800 CST
  • 3

我的 opensuse 11.3 崩溃了，这就是我安装 opensuse 12.1 的原因。在我安装（通过 yast）并编辑 /etc/passwd 之后

我这样做：

 rcpostgresql start

这显示在 /var/log/messeges

~ # less  /var/log/messages  | grep postgres
Dec 27 10:43:08 t1libora1 shadow[2393]: new group added - group=postgres, gid=26, by=0
Dec 27 10:43:08 t1libora1 shadow[2393]: running GROUPADD_CMD command - script=/usr/sbin/groupadd.local, account=postgres, uid=26, gid=0, home=, by=0
Dec 27 10:43:08 t1libora1 useradd[2396]: new account added - account=postgres, uid=26, gid=26, home=/var/lib/pgsql, shell=/bin/bash, by=0
Dec 27 10:43:08 t1libora1 useradd[2396]: running USERADD_CMD command - script=/usr/sbin/useradd.local, account=postgres, uid=26, gid=26, home=/var/lib/pgsql, by=0
Dec 27 11:08:45 t1libora1 su: (to postgres) root on none
Dec 27 11:08:45 t1libora1 postgresql[2998]: Starting PostgreSQL2011-12-27 13:08:45 GMT   FATAL:  los archivos de base de datos son incompatibles con el servidor
**Dec 27 11:08:45 t1libora1 postgresql[2998]: 2011-12-27 13:08:45 GMT   DETALLE:  El directorio de datos fue inicializado por PostgreSQL versión 8.4, que no es compatible con esta versión 9.1.1.**
Dec 27 11:08:50 t1libora1 postgresql[2998]: pg_ctl: no se pudo iniciar el servidor.
Dec 27 11:08:50 t1libora1 postgresql[2998]: Examine el registro del servidor.
Dec 27 11:08:50 t1libora1 postgresql[2998]: ..failed
Dec 27 11:08:50 t1libora1 systemd[1]: postgresql.service: control process exited, code=exited status=1
Dec 27 11:08:50 t1libora1 systemd[1]: Unit postgresql.service entered failed state.

我该如何迁移？

postgresql linux