مشکل عدم ران شدن mysql و ارور لاگ آن

[sadeght]

mysql ران نمی شود وقتی هم ارور لاگ را بررسی کردم این موارد بود :

130824 17:08:19 mysqld_safe Starting mysqld daemon with databases from /var/lib$
130824 17:08:19 [Note] Plugin 'FEDERATED' is disabled.
130824 17:08:19 InnoDB: The InnoDB memory heap is disabled
130824 17:08:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130824 17:08:19 InnoDB: Compressed tables use zlib 1.2.3
130824 17:08:19 InnoDB: Using Linux native AIO
^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ibO0CpvR' (Errcode: 28)
130824 17:08:19  InnoDB: Error: unable to create temporary file; errno: 28
130824 17:08:19 [ERROR] Plugin 'InnoDB' init function returned error.
130824 17:08:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130824 17:08:19 [ERROR] Unknown/unsupported storage engine: InnoDB
130824 17:08:19 [ERROR] Aborting

130824 17:08:19 [Note] /usr/sbin/mysqld: Shutdown complete

[nginxweb]

درود
یکبار تنظیمات my.cnf را خالی کنید و اقدام به استارت کنید اگر موفق نشدید باید سرور بررسی گردد و نمیشه دقیق موردی را گفت چون error مربوط به InnoDB هستش و باید default-storage-engine بررسی گردد

[sadeght]

همین خطا هست در ارور لاگ ها و ران نمی شود :

service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server.

دقیقا چکار کنم چطوری حل می شود ؟

[sadeght]

دوستان کسی نیست کمک کنه؟

[sadeght]

منتظر راهنمایی دوستان هستیم...

[sadeght]

بالاخره حل کردم ::

توضیح مشکل :

بهترین راه rebuild مجدد mysql هست که مشکل را حل و فصل می کند.

موفق باشید....

[mohammadoc]

این ارورو میده.چیکار کنم؟
2013-08-26 0907 3428 [Note] Plugin 'FEDERATED' is disabled.
2013-08-26 0907 fa4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-08-26 0907 3428 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-26 0907 3428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-26 0907 3428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-26 0907 3428 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-26 0907 3428 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-26 0907 3428 [Note] InnoDB: Completed initialization of buffer pool
2013-08-26 0907 3428 [Note] InnoDB: The first specified data file C:\Users\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2013-08-26 0907 3428 [Note] InnoDB: Setting file C:\Users\xampp\mysql\data\ibdata1 size to 10 MB
2013-08-26 0907 3428 [Note] InnoDB: Database physically writes the file full: wait...
2013-08-26 0908 3428 [Note] InnoDB: Setting log file C:\Users\xampp\mysql\data\ib_logfile101 size to 5 MB
2013-08-26 0908 3428 [Note] InnoDB: Setting log file C:\Users\xampp\mysql\data\ib_logfile1 size to 5 MB
2013-08-26 0909 3428 [Note] InnoDB: Renaming log file C:\Users\xampp\mysql\data\ib_logfile101 to C:\Users\xampp\mysql\data\ib_logfile0
2013-08-26 0909 3428 [Warning] InnoDB: New log files created, LSN=45781
2013-08-26 0909 3428 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-08-26 0909 3428 [Note] InnoDB: Doublewrite buffer created
2013-08-26 0910 3428 [Note] InnoDB: 128 rollback segment(s) are active.
2013-08-26 0910 3428 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-08-26 0911 3428 [Note] InnoDB: Foreign key constraint system tables created
2013-08-26 0911 3428 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-08-26 0911 3428 [Note] InnoDB: Tablespace and datafile system tables created.
2013-08-26 0911 3428 [Note] InnoDB: Waiting for purge to start
2013-08-26 0911 3428 [Note] InnoDB: 5.6.11 started; log sequence number 0
2013-08-26 0911 3428 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: bd2dcf51-0e0f-11e3-9e8d-001e8cb884a8.
2013-08-26 0911 3428 [Note] Server hostname (bind-address): '*'; port: 3306
2013-08-26 0911 3428 [Note] IPv6 is available.
2013-08-26 0911 3428 [Note] - '::' resolves to '::';
2013-08-26 0911 3428 [Note] Server socket created on IP: '::'.
2013-08-26 0911 3428 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2013-08-26 0911 3428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2013-08-26 0911 3428 [ERROR] Aborting


2013-08-26 0911 3428 [Note] Binlog end
2013-08-26 0911 3428 [Note] Shutting down plugin 'partition'
2013-08-26 0911 3428 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_METRICS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_CMP'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-08-26 0911 3428 [Note] Shutting down plugin 'INNODB_TRX'
2013-08-26 0911 3428 [Note] Shutting down plugin 'InnoDB'
2013-08-26 0911 3428 [Note] InnoDB: FTS optimize thread exiting.
2013-08-26 0911 3428 [Note] InnoDB: Starting shutdown...

[sadeght]

شما هم دقیقا مشکل بنده رو داشتید

بالا توضیح رو نوشتم مجددا mysql را rebuild کنید حل می شود مشکل تون نتونستید دسترسی برام پیغام خصوصی کنتید درست کنم براتون موفق باشید

[beniii]

روش رفع مشکل:
بررسی وضعیت سرویس mysql و رفع مشکل عدم اجرا | Cpanel - مرجع مقالات سی پنل

[ezio Auditore]

Error: MySQL shutdown unexpectedly.
12:10:02 PM [mysql] This may be due to a blocked port, missing dependencies,
12:10:02 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:10:02 PM [mysql] Press the Logs button to view error logs and check
12:10:02 PM [mysql] the Windows Event Viewer for more clues
12:10:02 PM [mysql] If you need more help, copy and post this
12:10:02 PM [mysql] entire log window on the forums
چی کار کنم؟
mer c