مشکل عدم ران شدن 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 09:54:07 3428 [Note] Plugin 'FEDERATED' is disabled.
2013-08-26 09:54:07 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 09:54:07 3428 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-26 09:54:07 3428 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-26 09:54:07 3428 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-26 09:54:07 3428 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-26 09:54:07 3428 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-26 09:54:07 3428 [Note] InnoDB: Completed initialization of buffer pool
2013-08-26 09:54:07 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 09:54:07 3428 [Note] InnoDB: Setting file C:\Users\xampp\mysql\data\ibdata1 size to 10 MB
2013-08-26 09:54:07 3428 [Note] InnoDB: Database physically writes the file full: wait...
2013-08-26 09:54:08 3428 [Note] InnoDB: Setting log file C:\Users\xampp\mysql\data\ib_logfile101 size to 5 MB
2013-08-26 09:54:08 3428 [Note] InnoDB: Setting log file C:\Users\xampp\mysql\data\ib_logfile1 size to 5 MB
2013-08-26 09:54:09 3428 [Note] InnoDB: Renaming log file C:\Users\xampp\mysql\data\ib_logfile101 to C:\Users\xampp\mysql\data\ib_logfile0
2013-08-26 09:54:09 3428 [Warning] InnoDB: New log files created, LSN=45781
2013-08-26 09:54:09 3428 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-08-26 09:54:09 3428 [Note] InnoDB: Doublewrite buffer created
2013-08-26 09:54:10 3428 [Note] InnoDB: 128 rollback segment(s) are active.
2013-08-26 09:54:10 3428 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-08-26 09:54:11 3428 [Note] InnoDB: Foreign key constraint system tables created
2013-08-26 09:54:11 3428 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-08-26 09:54:11 3428 [Note] InnoDB: Tablespace and datafile system tables created.
2013-08-26 09:54:11 3428 [Note] InnoDB: Waiting for purge to start
2013-08-26 09:54:11 3428 [Note] InnoDB: 5.6.11 started; log sequence number 0
2013-08-26 09:54:11 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 09:54:11 3428 [Note] Server hostname (bind-address): '*'; port: 3306
2013-08-26 09:54:11 3428 [Note] IPv6 is available.
2013-08-26 09:54:11 3428 [Note] - '::' resolves to '::';
2013-08-26 09:54:11 3428 [Note] Server socket created on IP: '::'.
2013-08-26 09:54:11 3428 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2013-08-26 09:54:11 3428 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2013-08-26 09:54:11 3428 [ERROR] Aborting


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

[sadeght]

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

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

[beniii]

روش رفع مشکل:
بررسی وضعیت سرویس mysql و رفع مشکل عدم اجرا | Cpanel - مرجع مقالات سی پنل (http://www.serversetup.ir/Cpanel/2013/08/%D9%88%D8%B6%D8%B9%DB%8C%D8%AA-%D8%B3%D8%B1%D9%88%DB%8C%D8%B3-mysql)

[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